Session Variables (again!)

[Ray]

Having been shown how to pass Session Variables across pages, I tried to run
a query with the Session Variable as a parameter, but I didn't work. The
query is "SELECT * FROM tblMember where Identifier= ::Identifier::", where
Identifier is the passed variable. It appears on the page correctly as a
number, and the box it appears in is called Identifier.

 

[Thomas A. Rowe]

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") & "'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Ray]

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

 

[Thomas A. Rowe]

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") & "'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

 

[Ray]

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") & "'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Having been shown how to pass Session Variables across pages, I

tried to
run

a query with the Session Variable as a parameter, but I didn't work. The
query is "SELECT * FROM tblMember where Identifier= ::Identifier::", where
Identifier is the passed variable. It appears on the page correctly as a
number, and the box it appears in is called Identifier.

 

[Thomas A. Rowe]

Ray,

That should work, as I use it all the time, however I code by hand and do not use the DRW. You will
need to wait for someone else to assist you that uses the DRW.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") & "'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Having been shown how to pass Session Variables across pages, I tried to
run
a query with the Session Variable as a parameter, but I didn't work. The
query is "SELECT * FROM tblMember where Identifier= ::Identifier::",
where
Identifier is the passed variable. It appears on the page correctly as a
number, and the box it appears in is called Identifier.

 

[dave]

Can you display your FULL SQL string and confirm you are using the FP DRW?

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

it

may

appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier")

&

"'

work.

The

correctly
as a

 

[Ray]

OK, thanks for your help anyway.

Ray

Ray,

That should work, as I use it all the time, however I code by hand and do not use the DRW. You will
need to wait for someone else to assist you that uses the DRW.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software;

it
may

appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" &

Session("Identifier") &
"'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Having been shown how to pass Session Variables across pages, I tried to
run
a query with the Session Variable as a parameter, but I didn't

work.
The

query is "SELECT * FROM tblMember where Identifier= ::Identifier::",
where
Identifier is the passed variable. It appears on the page

correctly
as a

number, and the box it appears in is called Identifier.

 

[Áíôþíçò]

Is there a chance that the opening double-quote is missing?

"SELECT * FROM tblMember WHERE Identifier = " & ID
^

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com

O/H Ray Ýãñáøå:

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it

may

appear in a different language depending on how the driver is

configured.

operator) in

query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") &

"'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Having been shown how to pass Session Variables across pages, I

tried to

The

as a

 

[Ray]

It's exactly as Thomas suggested - SELECT * FROM tblMember WHERE Identifier=
" & ID
Yes I am using FP DRW.

Can you display your FULL SQL string and confirm you are using the FP DRW?

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software;

it

may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" &

Session("Identifier")

& work. correctly
as a

 

[Ray]

Well not really because you don't put the opening quote in when you use the
DRW. I tried it anyway, but it still gives an error.
Thanks anyway

Is there a chance that the opening double-quote is missing?

"SELECT * FROM tblMember WHERE Identifier = " & ID
^

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com

O/H Ray Ýãñáøå:

Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp


Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it
may

appear in a different language depending on how the driver is
configured.

operator) in

query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") &
"'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Having been shown how to pass Session Variables across pages, I

tried to

run

a query with the Session Variable as a parameter, but I didn't work.
The

query is "SELECT * FROM tblMember where Identifier= ::Identifier::",

where

Identifier is the passed variable. It appears on the page correctly

as a

number, and the box it appears in is called Identifier.

 

[dave]

Ahh - now we are getting somewhere.
You are trying to enter the code into the Wizard - you cant do that.
You need to modify the actual code behind it. The DRW does not accept
session variables (or ordinary variables) by default.
You need to customise it.

One way is the "diet" that is shown here :
www.outfront.net/spooky/
Then you can modify the SQL string (in code) to accept variables.

Well not really because you don't put the opening quote in when you use the
DRW. I tried it anyway, but it still gives an error.
Thanks anyway

Is there a chance that the opening double-quote is missing?

"SELECT * FROM tblMember WHERE Identifier = " & ID
^

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com

O/H Ray Ýãñáøå:

it

may

appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software; it

may

appear in a different language depending on how the driver is

configured.

-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing

operator) in

query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" & Session("Identifier") &

"'

If "Identifier" is a number or autonumber field use:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Having been shown how to pass Session Variables across pages, I

tried to

run

a query with the Session Variable as a parameter, but I didn't work.

The

query is "SELECT * FROM tblMember where Identifier= ::Identifier::",

where

Identifier is the passed variable. It appears on the page correctly

as a

number, and the box it appears in is called Identifier.

 

[Ray]

Thanks - I've found a script editor to do it, and it works. It's hard work
though!. Thanks everybody for their help, and keep posted for the next
question from me!

Ray

Ahh - now we are getting somewhere.
You are trying to enter the code into the Wizard - you cant do that.
You need to modify the actual code behind it. The DRW does not accept
session variables (or ordinary variables) by default.
You need to customise it.

One way is the "diet" that is shown here :
www.outfront.net/spooky/
Then you can modify the SQL string (in code) to accept variables.

Well not really because you don't put the opening quote in when you use the
DRW. I tried it anyway, but it still gives an error.
Thanks anyway

Is there a chance that the opening double-quote is missing?

"SELECT * FROM tblMember WHERE Identifier = " & ID
^

_____________________________________________________________
B&D Technologies
http://www.bd-tech.com
Antoni Biliardis - antoni(at)bd-tech.com

O/H Ray Ýãñáøå:
Thomas
Sorry, but when I enter the query into the DRW, it cannot verify the
request. I get the following:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember WHERE Identifier= " & ID

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver software;

it

may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression 'Identifier= " & ID'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Ok, then

Dim ID
ID = Session("Identifier")

SELECT * FROM tblMember WHERE Identifier= " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Identifier is an AutoNumber field. However, with that I get this error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM tblMember where Identifier= " & Session("Identifier")

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/books.mdb.

The following error message comes from the database driver

software;

it

may

appear in a different language depending on how the driver is

configured.

-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing

operator) in

query expression 'Identifier= [ & Session(]Identifier")'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


What type of field is Identifier, text or autonumber or number.

If "Identifier" is a text field use:

SELECT * FROM tblMember where Identifier= '" &

Session("Identifier")

&