[thelist] SQL text form box
Matthias Ritzkowski
Matt at grndwtr.com
Thu Jun 28 08:01:09 CDT 2001
Hi Dan!
I admit I did not even read that far as the SQL statement!
Here's what I do with difficult SQL strings:
Use a Response.Write to display the string on the screen.
Then cut and paste that into your SQL frontend and test it there.
This way you see problems right away.
Matthias
<snip>
> The only thing that glares at me (I'm no ASP guru) is that the variable
> references to varLastName and varFirstName within the actual sql statement
> need to be pulled out from the string so they can be parsed.
> Thus
> : "WHERE (((People.PeopleNameLast)='varLastName') AND
> : ((People.PeopleNameFirst)='varFirstName'));"
>
> becomes:
>
> : "WHERE (((People.PeopleNameLast)='" & varLastName & "') AND
> : ((People.PeopleNameFirst)='" & varFirstName &"'));"
</snip>
More information about the thelist
mailing list