by: Brian Bendtsen |
last post by:
Hi
I have a strange problem with a mysql database and ASP.
I try to retrieve a value from a table I have just created with a very
simple sql statement.
Ex. SELECT myValue FROM myTable WHERE...
|
by: Simon Gare |
last post by:
Hi have succesfully exported data from db to excel and dynamically generated
filename, problem is I need a space between the invoice ID and Customer
name, at present it generates the data but...
|
by: atljpe |
last post by:
In Excel: My query can only be refreshed if your using z: as your drive header. I want to change it so anyone can refresh this query wether they're using x, y, or z for their drive header:
The...
|
by: Torie |
last post by:
I am successful pulling the appropriate data from a database table and a view (which contains 2 tables) via SQL query tool. However, when I make the selection from my ASP code, several fields will...
|
by: ITChica |
last post by:
Hello everyone- quick question:
I am trying to create a query in excel using a field alias. I've done this in the past in SQL by using table.fieldName AS aliasName. But when doing this in excel,...
|
by: bwestover |
last post by:
If I enter the value 39301.5 into a cell and format it as date, I get the following result:
08/07/2007 12:00 PM
However, if I put 39301.5 into this statement in SQL:
Select cast(39301.5 as...
|
by: silversubey |
last post by:
Hello all.
I have an excel query that pulls data from a SQL database. I have 2 parameters that represent the and of a between criteria. Here is the query.
SELECT CltDue.CDClientName
,...
|
by: srinivasan2009 |
last post by:
I want to convert figure (ie., Value) into words(in Rs) using Formulae can anybody help me............in Excel sheet
|
by: greggui9029 |
last post by:
Hi,
I have some querytables using OLE DB provider in Excel workbook. Is there any way to connect to the external data programmly without refreshing querytables? i.e. I don't want to refresh Excel...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
1
