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
