multiple inserts, no solution

2003-10-13 Thread mayo
BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they wi

RE: multiple inserts, no solution

2003-10-13 Thread mayo
Jeremy, when I insert one date at a time there is no problem.   The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, wi

RE: multiple inserts, no solution

2003-10-13 Thread Ian Skinner
ble A, maintaining the data integrity. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:33 AM To: CF-Talk Subject: RE: multiple inserts, no solution Jeremy, w

RE: multiple inserts, no solution

2003-10-13 Thread mayo
jeremy, I'll give cftransaction,cftry/cfcatch; and everything another look. thx gil   -Original Message-   From: Jeremy Brodie [mailto:[EMAIL PROTECTED]   Sent: Monday, October 13, 2003 1:23 PM   To: CF-Talk   Subject: Re:multiple inserts, no solution   Gil,   When you output getClassDa

Re: multiple inserts, no solution

2003-10-13 Thread Pete Ruckelshaus
changes to this, but it might require firing the neurons up a bit. Pete   - Original Message -   From: mayo   To: CF-Talk   Sent: Monday, October 13, 2003 10:52 AM   Subject: multiple inserts, no solution   BACKGROUND INFO:   I'm creating an admin form allowing a user to enter

RE: multiple inserts, no solution, THX ALL

2003-10-14 Thread mayo
thx all   -Original Message-   From: Jeremy Brodie [mailto:[EMAIL PROTECTED]   Sent: Tuesday, October 14, 2003 2:02 PM   To: CF-Talk   Subject: Re:multiple inserts, no solution, thx but one more question   Gil,   See Ian's advice on using a list loop. They are very handy for this situatio

RE: multiple inserts, no solution, thx but one more question

2003-10-14 Thread mayo
x27;t do a so what would one do it if there were 10 inserts or 50? Gil   -Original Message-   From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]   Sent: Monday, October 13, 2003 3:16 PM   To: CF-Talk   Subject: Re: multiple inserts, no solution   You didn't mention what DB

RE: multiple inserts, no solution, thx but one more question

2003-10-14 Thread Ian Skinner
amento, CA -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 10:34 AM To: CF-Talk Subject: RE: multiple inserts, no solution, thx but one more question Thx for all who wrote. It works now. (I'm using Access2000) RE: The CreateODBCDate.     It wor