| << | Quit Smoking or you're fired | Blog Of the Week - TWI | >> |
Find the Last inserted Auto increment ID in MYSQL with ASP
| posted at 13:58:19 By Flipping Heck! | Posted In Coding |
It's taken me ages to find out how to do this (what turns out to be a) relatively simple operation.
Here's the problem. Table 1 has a user_id which is auto incremented by MYSQL. Table 2 has an auto incremented login_id but also requires the user_id. Here's how we get one ID from one table to the other:
objRS.source = "Select LAST_INSERT_ID() from Table1"
objRS.open
LastID = objRS("LAST_INSERT_ID()")
objRS.Close
Simple! We can then refer to the LastID in Table 2
Like this article? Add it to:
| Click To View Comments (2) | Trackback URL | |
| << | Quit Smoking or you're fired | Blog Of the Week - TWI | >> |
Archive
Categories
Blogging Business Coding Design Email From My Mobile Google GTD/Productivity Humour Life Hacks Motivation Movie Reviews News Personal Project Management Psychology/Body Language Quizzes/Tests Rants Review Site News Software Tips TechnicalRecent Posts
Threat of redundancy forcing us into unpaid overtime How to run an appraisal Stephen Covey launches a new Community Site Multitasking revisited: How much time are we wasting? How to run Productive Meetings - Guest post at Simpleology.com "Productive" Magazine Launched Shock Horror! Obama may lose Blackberry priviledges!Recent Comments
Adrian says...
The link for BtB4 (Projects) and BtB5 (Review) is the same link. Just thought you should know.Thank....
web design says...
Hi, I have just visited your site and the info you have covered has been of great interest to me.....
web hosting says...
Great post, I admire the writing style :) A little off topic here but what theme are you using? Look....
Kevin says...
I found this post very informative. Here is another helpful body language tip. When you see their ey....
Chris says...
Randomly came across this post when searching for a solution to my own procrastination. I'd definit....
Pablo says...
Companies are not perfect; job policies in many cases are indeed absurd and unprofitable in the long....
Rojae Braga says...
Working beyond your usual working hours does not really mean increasing your productivity. In most t....
Quiz Master says...
A site that allows you to quickly create quizzes, tests and questions with full user tracking and le....
Ed says...
Hi there your readers may be interested in a new alternative to GTD called Dooster. It's a great on....
vijay says...
pig-headed weasel, they may ignore you completely and get you fired for going over their heads but i....
Stats
since February 2004
73 Reading Now
Search
View the Tag Cloud or View the Category Cloud
Subscribe
RSS Feed
Subscribe to the RSS Feed by clicking on the icon below and add the URL to your feed reader
Featured Posts
GTD - Back to basics 6 - The round-up Managing Projects in one Place Managing Web Projects - The Whole Shebang Managing your time and procrastination levels with the ktDPlan ktGTD - Projects/Actions with a Moleskine Mindmapping Resources Manage Your Manager - How to cope with Ineffectual leadership Writing good meeting minutes revisited Getting Things Done with Thunderbird Get people re-involved: Change the format Project and Next Action Organisation Time Management: Procrastination vs GTD and Non-Conditional Scheduling Organising your desktop Recover "permanently" deleted items in Outlook Grocery Shopping Hack: Weekly Shopping Lists Using Flags and Rules In Outlook 2003 for GTD Make your blog search engine friendly My Life Organised and Outlook [argh!] How to market your blog and keep your readers GTD with a Pocket PC Improving Outlook with a custom dashboard Organising your Digital Photos Managing Tasks in Outlook Organising and Managing your DVD collection What is GTD?Popular Posts
How to write good meeting minutes Writing good meeting minutes revisited Getting Things Done with Thunderbird Grocery Shopping Hack: Weekly Shopping Lists 7 Habits: Habit 4 - Think Win/Win Improving Outlook with a custom dashboard Writing Meeting Minutes - Meeting Mate v3 Organising your desktop GTD - Back to basics 6 - The round-up 7 Habits - Habit 5: Seek first to understand then to be understoodBlog Roll
A Bloke Near Where I live Cranky Middle Manager Show Dilbert Focused Performance GTD Wannabe My Boyfriend is a Twat Project Management Institute - eBusiness Specific Interest Group Random Acts Of Reality RoundACow Smidsy The Mad Admin The Register Wide Awake Wesley Wil Wheaton In Exile Suggest a siteAdmin
To log in, enter your usernameand password below:
This website and all its contents are © Katy Whitton 2012
