[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