Well not sure I understand the first part, but if you have a form that
passes a LIST of song titles via list element to the action page
You can check the DB prior to doing the insert to check if it exists or not.
--- Form Action --
cfquery name=qCheckDB
/cfquery
!--- If record does not
First off...shouldn't you all be out doing something other
than working? ;-) Since you're not out somewhere having way
too much fun, I could use some enlightenment here.
I have a form passing multiple values via some checkboxes, I
think I've got the insert down ok for that with the
Dave...sorry for the lack of information, after read what I posted I thought
I should have given a little more information. My form looks like this:
form action=#self#?fuseaction=admin.selectSongs name=songSelect
method=post
input type=text name=week_of size=25 maxlength=50 value= /
This is
Dave...sorry for the lack of information, after read what I
posted I thought I should have given a little more
information. My form looks like this:
form action=#self#?fuseaction=admin.selectSongs name=songSelect
method=post
input type=text name=week_of size=25 maxlength=50 value= /
This was copied from a separate display page I setup for band members to
download their songs from, just hadn't pulled out the link refs yet. This
isn't for the public, actually it's for members of a worship band from
church...to make It a little easier for folks to get to their material for
the
I am passing this to:
cfloop list=#Form.songTitle# index=item cfquery
name=current_week datasource=#dsdata# username=myname
password=mypwd
INSERT INTO current_week (song_title)
VALUES ('#item#')
/cfquery
/cfloop
I'm not seeing where to shoe-horn the week_of value into the
[mailto:[EMAIL PROTECTED]
Sent: Saturday, March 10, 2007 8:03 PM
To: CF-Talk
Subject: RE: need insert help please
I am passing this to:
cfloop list=#Form.songTitle# index=item cfquery
name=current_week datasource=#dsdata# username=myname
password=mypwd
INSERT INTO current_week (song_title
7 matches
Mail list logo