Mike
|
| Posted: 03/30/2002, 12:13 AM |
|
I cannt understand some asp code that generated using CC can any one tell me about this code :
Dim rs
Dim sWhere : sWhere = ""
Dim sOrder : sOrder = ""
Dim sSQL : sSQL = ""
what is the meanning of "varname : varname" ?
and this :
sWhere = sWhere & "c.[info]='" & replace(ps_info, "'", "''") & "'"
What is the c in c.[info] ?
thanks
|
|
|
 |
Alex Alexapolsky
|
| Posted: 03/30/2002, 5:38 AM |
|
The code in the beginning declares variable an initalizes them with empty values
Probably info is table name and table names when used in ms access
should be enclosed into square brackets.
|
|
|
|
Mike
|
| Posted: 03/31/2002, 3:01 AM |
|
What is the problem with this Dim x ="" instad of Dim x:x =""
And in the second question what is the mainning of c in the c.[info] ?
thanks
|
|
|
|
Nicole
|
| Posted: 04/01/2002, 1:11 AM |
|
Mike,
about c.[info]. "c" is table alias. CC creates table aliases from first letter of table name. E.g. if table name is "members", then table alias generated by CC would be "m".
|
|
|
|
Mike
|
| Posted: 04/02/2002, 2:45 AM |
|
OK
What is the problem with this Dim x ="" instad of Dim x:x =""
|
|
|
|
Code Warrior
|
| Posted: 04/11/2002, 1:28 PM |
|
Mike,
Dim x ="" is simply a syntax error in ASP. It is not allowed.
Dim x:x ="" is a short one-line way of coding this....
Dim x
x = ""
Either one will work.
|
|
|
|
