vmorales
asked on
Using Forms with ASP/ADO/VBScript
I have an Access database with 1 table. Most Items within the table are text with the exception of 2 items that are Integers. The form, of course, has fields contained with the database. 2 of the fields that are Integer types within the database are defined in HTML like all other fields (Input type=text...). Here is my problem: if the fields that are of the type integer have not been filled in upon submitting the form, I get "type mismatch" error. If the fields have info everything is fine. Also, I do not require the fields to be filled. I also understand the the Val function in VBScript does not work correctly.
Please help!
Please help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That sounds very good. YOu can email me at masseym@mrqcorp.com. I am still in the process of coming up with "material" to send, but will have it within the next two-three days. I will await your email.
Thanks,
Matt
Thanks,
Matt
ASKER
That was a simple solution. I suppose I made the problem more complex than it was.
By the way, I work for a financial institution and wear many hats. I noticed that you have started your own company. I would be interested in so material/information about your company. We will be in the near future look into offering Internet services. At this time I am working on a intranet project. I will email you with an address to sent info to. Again, thanks.