Formatting SQL in Prontpage 2003

[Dan]

I am trying to format a variable passed from a FP form to
an Access DB. None of the typical SQL formats seem to
work in FP passeding variable. Example.. Passing a text
variable requires the the variable be encased in double
colons> ::name:: . This works but I cannot get any kind
of string search to work no matter how I format. I've
tried WHERE (lastname LIKE ::name%: and every other
variations I can think of... I need help with formatting
these FP variables...

 

[Jim Buyens]

-----Original Message-----

I am trying to format a variable passed from a FP form to
an Access DB. None of the typical SQL formats seem to
work in FP passeding variable. Example.. Passing a text
variable requires the the variable be encased in double
colons> ::name:: . This works but I cannot get any kind
of string search to work no matter how I format. I've
tried WHERE (lastname LIKE ::name%: and every other
variations I can think of... I need help with formatting
these FP variables...

In your example, the correct format should be

WHERE (lastname LIKE '::name::%')

After substitution, this results in

WHERE (lastname LIKE 'smit%')

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Kathleen Anderson [MVP - FP]]

... I need help with formatting these FP variables...

SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430