I did something similar recently although not with dates using SQL. What
you might like to do is to write an SP which excepts a string parameter
containing each of the days (i.e. columns) that you want to update separated
by a comma i.e. '1,15,25' and then another parameter which holds the text
you want to insert. You can then use string manipulation fuctions to break
down the first parameter to get all of the columns to hit. You then build
up a SQL string and execute it using:
EXEC (SQLString)
Alternatively if you want to embed the SQL in your CF page then you can
dynamically build your SQL statement in CF.
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2000 15:29
To: [EMAIL PROTECTED]
Subject: calendar
Hello,
This probably is an easy one, but its too early forme today...
I have a calendar setup w/CF. Users can change/edit text in whatever single
day they choose. I would like to create CF code that can have them select a
row of dates and globally insert text in those selected days. Each day is a
column in my tablle.
Any ideas please?
Thanks.
Robert O.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
