Help with insertion

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Help with insertion

Logged in as: Guest

arrSession:exec spGetSession 2,3,976

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Help with insertion
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Help with insertion - 2/25/2004 6:59:58 PM

Orchid

Posts: 1
Score: 0
Joined: 2/25/2004
From:
Status: offline

I am using asp with VBScripts and MS Access ..
I have three tables and i want to insert into them ..
as the following
table a: (ID, Topic, Date)
table b: (qID , ID , Question)
table 3: (aID, qID , Answer)

I insert a topic and then i got the id of that topic and use another for to add question with the answers .. the problem that the question was inserted correctly without answer for that specfic topic

I just want some hints
I need your help please

Post #: 1

Re: Help with insertion - 8/17/2004 10:10:42 PM

Matt

Posts: 30
Score: 0
Joined: 8/17/2004
From: United Kingdom
Status: offline

This sounds like an SQL issue. What do you mean by Insert? I ask as it seems you may be miss useing the word a little... Unless you mean you are doing "insert into" in which case it seems like you may need to use two pairs of Inner Joins and run 1 long SQL statement to put all the data in at once.

This might help: http://www.w3schools.com/sql/sql_join.asp

(in reply to Orchid)