TruthInSatire
Programmer
I know I've asked this in the past but I still have not found the answer, and I desperately need help.
I use ASP to connect to an SQL Server database.
After I create a record set containing data from a table, the data in the record set takes a null or a '' value after I use it.
This is not my actual code only an example.
rs("editor"
= "Bob"
rs("editDate"
= "12/4/02"
response.write(rs("editor"
)
<br>
response.write(rs("editDate"
)
<br>
response.write(rs("editor"
)
<br>
response.write(rs("editDate"
)
produces the following output
Bob
12/4/02
<--- "Bob" should write here but it doesn't
<--- "12/4/02" should write here but it doesn't
This problem only exists in new tables or fiels added to an older existing database. If I created the record set using pre-existing fields the above example would work fine USING THE EXACT SAME CODE!?!?
The only thing I can think of causing this problem is I attemtped to create the field in an existing table using written SQL statements vice adding them directly to the database using sql server manager. The field created sucessfully, but now all newly created fields are hosed. That field has sence been removed and recreated with a different name directly in sql server manager. Could that have caused a problem somewhere?
As far as the database goes, I've tried deleting the new fields, recreate them with a different name. I've tried putting them in old and new tables. Still no luck.
I don't get any errors, it just doesn't work.
Somebody, please god help me, I've fought with this problem for months and delayed projects because I can not figure out this issue. How many software developers does it take to change a light bulb?
None: it works in everyone else’s office, it must work in yours too.
I use ASP to connect to an SQL Server database.
After I create a record set containing data from a table, the data in the record set takes a null or a '' value after I use it.
This is not my actual code only an example.
rs("editor"
rs("editDate"
response.write(rs("editor"
<br>
response.write(rs("editDate"
<br>
response.write(rs("editor"
<br>
response.write(rs("editDate"
produces the following output
Bob
12/4/02
<--- "Bob" should write here but it doesn't
<--- "12/4/02" should write here but it doesn't
This problem only exists in new tables or fiels added to an older existing database. If I created the record set using pre-existing fields the above example would work fine USING THE EXACT SAME CODE!?!?
The only thing I can think of causing this problem is I attemtped to create the field in an existing table using written SQL statements vice adding them directly to the database using sql server manager. The field created sucessfully, but now all newly created fields are hosed. That field has sence been removed and recreated with a different name directly in sql server manager. Could that have caused a problem somewhere?
As far as the database goes, I've tried deleting the new fields, recreate them with a different name. I've tried putting them in old and new tables. Still no luck.
I don't get any errors, it just doesn't work.
Somebody, please god help me, I've fought with this problem for months and delayed projects because I can not figure out this issue. How many software developers does it take to change a light bulb?
None: it works in everyone else’s office, it must work in yours too.