Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Putting a session variable into a recordset

Putting a session variable into a recordset

Thread began 9/01/2009 12:04 pm by martin317528 | Last modified 9/02/2009 9:29 am by martin317528 | 987 views | 1 replies

9/02/2009 9:29 amJason ByrnesWebAssist

When creating the recordset in dreamwever using the Advanced view, to use a session variable, you need to create a variable in the recordset.

Create the SQL as:
WHERE table1.field1 LIKE '%exampleText1%' AND table2.fieldB LIKE '%paramSession%'

The click the plus button in the variable section:
Name: paramSession
Type: Integer
Defualt Value: -1
Run Time Value: $_SESSION['exampleTextB']

This will cause "paramSession" in the SQL Above to be replaced with the value stored in the session variable if it is set or -1 if it is not.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.