Variable in SQL Statement

[Jeff Honken]

Ken, that worked great.  Thanks, Jeff

-----Original Message-----
From: Ken Ray [mailto:kray at sonsothunder.com] 
Sent: Monday, February 05, 2007 5:43 PM
To: How to use Revolution
Subject: Re: Variable in SQL Statement

On Mon, 5 Feb 2007 17:30:19 -0500, Jeff Honken wrote:

> I've been trying to put a wildcard "%" into a SQL statement that
> contains a variable.  I just can't seem to find the right format.
> Here's the SQL statement:
> 
> put revQueryDatabase(gConID, "SELECT ClaimNum FROM AccountEntry WHERE
> ClaimNum LIKE '" & QueryDate & "'&% ORDER BY ClaimNum DESC LIMIT 1")
> into q

I think it's because the ampersand is inside the query itself, try this:

 put revQueryDatabase(gConID, "SELECT ClaimNum FROM AccountEntry WHERE
 ClaimNum LIKE '" & QueryDate & "%' ORDER BY ClaimNum DESC LIMIT 1")
 into q

Ken Ray
Sons of Thunder Software, Inc.
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution