Gab
|
| Posted: 03/20/2003, 10:32 AM |
|
SELECT DISTINCTROW Sum([Shipment].[Weight])
FROM [Shipment]
WHERE [Shipment].[CustomerName]= Connection.ToSQL(CustomerName.SQLText, CustomerName.DataType)
How do I execute that query and store the results into a variable ?
I am using ASP 3.0
and CCS
Thanks in advanced
|
|
|
 |
DaveRexel
|
| Posted: 03/20/2003, 10:49 AM |
|
Hello Gab,
The following article should help you
http://www.rexdesign.com/ccs/kb.php?event_id=15&categor...2&language_id=7
Greetings
Dave
|
|
|
|
Gab
|
| Posted: 03/20/2003, 9:52 PM |
|
Thank you very much, it helped me find the answer.
In addition to that link, I found the following
http://www.gotocode.com/art.asp?art_id=234&FormArticle_Page=2#Article
In the end, this is the code I used.
Dim weightTotals : weightTotals = CCDLookUp("SUM(Weight)","Shipment","CustomerName=" & Connection.ToSQL(Customer.CustomerName.SQLText,Customer.CustomerName.DataType) & _
"AND Billed = 'FALSE' AND BillNow = 'TRUE'",DBArusa)
Again, I am using ASP 3.0 , on CCS 2b4
|
|
|
|
|
