I have a recordset that was created by passing a SQL string to Access. The SQL string had "SELECT * FROM" at the beginning so I don't know what fields I have. Is there a function I can use to get the field names from the recordset?
I need to export a table's design for documentation purposes. The only think I've been able to do is export the data. How can I export the field names, data type, length, and the allow nulls flag?
I have a form that writes a text area field to a database. The field can get long so I'm using a textarea control for entry. When someone wants to add to this field, I want them to enter it in a new textarea control and I append the new string to the old string and write it to the database. I...
Thank you Jeremy, that did the trick. I also have a javascript calendar that fills the first date field by clicking on the date. When I use the calendar rather than entering the date by hand, it does not automatically populate the second date field. Is there something about that javascript...
I was on an ASP page that asked for my name. I typed my name into the form and when I left the field, either through tabbing or clicking on the next field, it automatically converted what I typed to uppercase. I wanted to see the source code for this page but it would not let me.
I need to do...
I did a little research and found that the problem is caused by using group bys, sorts, etc... I have a where clause and an order by in the sql statement, but they are necessary.
I'm doing a union query on an ASP page. The returned record set for the query is truncating a field that was defined as a memo field for the two tables being read. As best as I can tell, the fields being truncated are defined the exact way in both tables, and when reading either of the tables...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.