I am attempting to integrate results from
an SQL enquiry into a web page and I am
using Frontpage98's Database Region Wizard
to acheive this.
I have correctly configured ODBC on my
DB-server and when using the wizard
to extract data using what I would call 'static'
examples of SQL ie
SELECT * FROM db_table
I get the results I expect.
My problems are occuring when I
am trying to read the value passed to
the page with the DB-region from the
form that is calling it.
I have named the FORM name=search and
have a text area called b_name
When I invoke the option to insert a form element name
into the wizard I input 'b_name' and a piece of
VBSCRIPT? such as %%b_name%% gets generated.
I then enclose this in single quotes to complete the SQL
syntax and save the page. When I go to test it I am
getting 'NO Results' so.. obviously nothing is being retreived
and I,m not sure that the correct parameter substitution is taking
place. What could I be doing wrong?
Regards Stephen Martin