[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: HELP Dynamic Where Clause from ASP
From:       "Leif Johnston" <leif () technologycatalyst ! com>
Date:       2004-05-25 13:05:45
Message-ID: 2004052506494568-381450175 () technologycatalyst ! com
[Download RAW message or body]

I agree. It is key to see what you are actually sending over be careful about the number being a number vs text. Als the semicolon shouldn't be needed but the string needs to be loaded correctly.

---- Original Message ----
To: N Gangadhara Sanya <ngsanya@yahoo.co.uk>
From: Erich Dollansky <oceanare@pacific.net.sg>
Date: Tue, 25 May 2004 19:49:55 +0800
Subject: Re: HELP Dynamic Where Clause from ASP

Hi,

N Gangadhara Sanya wrote:

> If remove the ";" at the end it  fails to execute the statement.(Even the
> above one)

This is hard to believe. I never ever used this character in an SQL 
statement. I use JavaScript when I program for ASP.

> 
> sSql = "Select * from candidate_mis where candidateid > " &
> trim(Request.Form("txtCandID")) & ";"
> 
Can print the resulting sSql value to the output?

You can print it into an HTML comment and then view the source to see it.

Erich

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=leif@technologycatalyst.com



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]