Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › 'Type: text' for recordset variable not working

'Type: text' for recordset variable not working

Thread began 11/01/2018 9:19 am by s.joiner74419001 | Last modified 11/01/2018 6:41 pm by Ray Borduin | 236 views | 1 replies |

11/01/2018 9:19 am | #1 s.joiner74419001

'Type: text' for recordset variable not working

I am wanting to add a second variable to a recordset that will have its value determined by a URL parameter. the parameter will be "?status=Unpaid" so I need the variable to be a 'Text' type. but I get an error message ( Missing type for variable:status - Missing Run-Time Value for variable"status ) when trying to OK the recordset update. ( see screen shots in attachments )

How do use a variable here that has a text value?

Thanks in advance

11/01/2018 6:41 pm | #2 Ray BorduinWebAssist

You can't name the parameter the same name as a column that is in your SQL statement.

Try renaming your parameter to StatParam instead of just Status and this should work.

Did this help? Tips are appreciated...

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.