Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-23 : 18:29:25
|
Eric writes "Our db admin decided to create a field in an access db that contains a forward slash "/". When I write the SQL statement to run through asp its finding too many parameters. Is their a way to work around this?
TIA
strSQL= "SELECT PROJECT, (((Sum(RFAERIAL))+[Sum(RFU/G]))/5280) AS sumpreqcmiles from tblDesignData WHERE DESIGNBILL BETWEEN #" &Request.Form("txtFirstDate") & _
"# AND #" & Request.Form("txtSecondDate") & "# group by PROJECT"" |
|
|
|
|
|
/ in the field name