Ask a Question related to Coldfusion Database Access, Design and Development.
-
Martijn #1
Adding values from various fields..
Hello,
i'm trying to add a few values from multiple fields from 1 table.
like:
field a1 = 10
field a2 = 12
field a3 = 15
field a4 = 3
field a5 = 7
And i now would like a total of field a1 to a5. Not always 5 fields though..
could also be 12, could also be 1, or 100...
I've tried to look at forum's and multiple websites, but i can't find
anything.
Can any1 help me with this one ?
Thnx in advance
Martijn
Martijn Guest
-
Add values of two fields
Good day, I just want to know if it is possible using developers toolbox to sum values of two fields (field1 + field2 =field3) where field3 is the... -
Cant get the values from the NTEXT fields
Unfortunately I have to use the ODBC driver in order to connect to the SQL 2000 personal edition on my development workstation. but this is still... -
Concatenate fields with no values
I am running CF 5 with SQL Server 2000. I am looking to concatenate a person name, but not all names have a suffix or middle name. Sample SQL:... -
Adding points to a database ( adding / subtrating numeric values)
HI all, I have build a user database that comes with user points for browsing private section of my site. I would like to know what is the... -
Adding custom values and database values to DropDwonList
The other way is to create a DataTable, put the --None-- as the first Row, then read the datareader into the DataTable, and append the --other-- at...



Reply With Quote

