Classic ASP Discussion - Problem reading one db and writing to ano

Print Page | Close Window

Problem reading one db and writing to ano

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10287
Printed Date: 31 March 2026 at 2:42pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem reading one db and writing to ano

Posted By: shadowspell
Subject: Problem reading one db and writing to ano
Date Posted: 04 May 2004 at 1:33pm

I have a simple form that collegues use to submit 'names' and 'descriptions'. Upon submit, this is written to an Access db called 'NOM'.

I use another form that reads 'NOM' and populates itself with those 'names' and 'descriptions' with a radio button next to each name.

One vote is submitted via this form by clicking the radio button next to the name of the person they wish to vote for then clicking the submit button.

Upon submission of this vote, the results are written to another Access database called, 'VOTE'. But in every case, instead of one description being captured with the vote, all the descriptions from the 'NOM' db are being captured.

How can I capture the one description that goes with the name of the person being voted for?

Thanks,
Chris

-------------
~`^%
In Vino Veritas

Replies:

Posted By: Semikolon
Date Posted: 04 May 2004 at 2:43pm

why not use two tables in stead of two databases? much better and faster

to capture only one of the descriptions use WHERE field = '<data>' (single quotes only if it is text. numbers like this: WHERE field = number)