Ken, that worked great. Thanks, Jeff -----Original Message----- From: Ken Ray [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
