Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Adding autonumber in new record
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Adding autonumber in new record

 Post Reply Post Reply
Author
judo2000 View Drop Down
Groupie
Groupie
Avatar

Joined: 05 November 2002
Location: United States
Status: Offline
Points: 49
Post Options Post Options   Thanks (0) Thanks(0)   Quote judo2000 Quote  Post ReplyReply Direct Link To This Post Topic: Adding autonumber in new record
    Posted: 04 March 2003 at 2:42pm

I have a database for employees with different venues.  In the Employees table I have empID which is an auto number. empID is in all of the venue tables as well.  I have created a form that allows venue managers to see all the employees in the database whose venue ID matches their venue.  From this page then can add these employees to the venue schedule page, but I cannot add the record to the venue table in the DB because the only way I seem to be able to read the empID into the form is with:

<input type="text" name="empID" value="<%=rsSchedules("empID")">

But of course the empID is not text so when the add_emp.asp pages tries to add the new record to the venue table I get a type mismatch error.

Is there an easier way to either call the empID into the form (I don't care if the venue manager sees the ID or not) or to convert it into the proper form so it can be added to the table?

I appreciate any help.



Edited by judo2000
If you are not willing to work hard to realize your dreams, why bother dreaming?
Back to Top
Scott07 View Drop Down
Groupie
Groupie


Joined: 04 July 2002
Location: United Kingdom
Status: Offline
Points: 43
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scott07 Quote  Post ReplyReply Direct Link To This Post Posted: 05 March 2003 at 9:45am
just use clng(rsSchedules("empID"))
Back to Top
judo2000 View Drop Down
Groupie
Groupie
Avatar

Joined: 05 November 2002
Location: United States
Status: Offline
Points: 49
Post Options Post Options   Thanks (0) Thanks(0)   Quote judo2000 Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2003 at 12:46pm

Thanks I tried that and it worked, sort of.  I writes to the database now but it puts a 0 for the empID and increments the autonumber jbaID but everything else is left blank.  Any ideas?

Thanks,

If you are not willing to work hard to realize your dreams, why bother dreaming?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.