| Bug #41735 | problem with recordset variables usage/testing in asp... | ||
|---|---|---|---|
| Submitted: | 24 Dec 2008 18:40 | Modified: | 29 May 2013 11:56 |
| Reporter: | acid burn | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 5.0 | OS: | Windows |
| Assigned to: | Lawrenty Novitsky | CPU Architecture: | Any |
| Tags: | ASP, MySQL 5.0, ODBC 5.0, recordset, variables | ||
[24 Dec 2008 19:56]
Valeriy Kravchuk
Thank you for a problem report. What exact version of Connector/ODBS, 5.1.x, and MySQL server, 5.0.x, do you use?
[25 Dec 2008 7:07]
acid burn
mysql ver. 5.0.67 ODBC installer ver. 5.01.0005.. need anything else ?
[8 Jan 2009 14:59]
Jess Balint
Which version of MySQL were you using before upgrading? Can you include the schema for the "base_scroller" table?
[12 Jan 2009 14:39]
Tonci Grgin
Please provide info Jess requested.
[13 Feb 2009 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[29 May 2013 11:56]
Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.
Description: mysql: 5.0 odbc: 5.1 developing language: asp I have a problem that just started happening after I installed the mysql 5.0 In the past I could do do this: Code: <% set msgSet = conn.execute("select * from base_scroller where scroller_num = 1") %> check if it's not empty or anything else Code: <% if msgSet("scroller_name") <> "" then %> and if it is i could do anything with it (like showing it's value) Code: <%= msgSet("scroller_name") %> <% end if %> Now I can't do this, the "if" test doesn't work with the "msgSet("scroller_name")" and I have to redifine it first in another variable Code: <% scrollername = msgSet("scroller_name") %> then and only then I can do tests on it... Code: <% if scrollername <> "" then %> and show it too... Code: <%= scrollername %> <% end if %> the problem accures on all kinds of variables including data fields like: day(msgSet("scroller_date")) - doesn't work anymore.. why don't I have the option to do the operations on the mysql recordset variables like b4.... How to repeat: I do not know if it happenes for everyone, but testing variables directly should triger this right away.