Re: Looping through lists
select * from stillAtWork where somevalue = #currItemInList# and salary < #peanuts# order by salary #xyz# - Original Message - From: "Jon Tillman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 10:50 PM Subject: Looping through lists > Hey, I need to figure out how to loop though a list and perform a query for > each value returned in the list. Any ideas? > > -- > This Email is 100% Virus Free! How do I know? > Because no Microsoft products were used to > generate it! > > ::: > Jon Tillman > LINUX USER: #141163 > ICQ: 4015362 > [EMAIL PROTECTED] > http://tillman.freehosting.net > ::: > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Looping through lists
Hey, I need to figure out how to loop though a list and perform a query for each value returned in the list. Any ideas? -- This Email is 100% Virus Free! How do I know? Because no Microsoft products were used to generate it! ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: 'ing FORM Field Names Problem
Change it to:
NAME = #Evaluate("tempvar")#
and it should work. You don't really need to set the temp variable.
Remember, there is no variable named "form.tempcomment". You are already
past the rebuilding of the form name, which was done with:
At that point, tempvar = the value of #form.full_name_x#, where x is the
current loop index.
You could even shorten the code by using something like:
NAME = EVALUATE('full_name_'& PersonsAttending)
This will print the value you want. You would need to assign a variable in
order to really use that value.
INSERT INTO MyTable (full_name)
VALUES ('#myName#')
Good luck!
Jeff
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 10:52 PM
To: [EMAIL PROTECTED]
Subject: RE: 'ing FORM Field Names Problem
Dana,
Thanks for your suggestion and code snippet. I'm still not getting it to
work though. Here's what I've tried:
Name = #FORM.tempcomment#
When I run this, I get the same error I've been having:
Error message follows-
Error Diagnostic Information
An error occurred while evaluating the expression:
#FORM.tempcomment#
Error resolving parameter FORM.TEMPCOMMENT
The specified form field cannot be found. This
problem is very likely due to the fact that you
have misspelled the form field name.
End Error Message-
I can't figure out how to get CF to understand that where I have
#FORM.tempcomment#, I want it to read the variable tempcomment so that it
comes out as #FORM.full_name_1# (or #FORM.full_name_2#, etc.)
How do I cram this thing down CF's throat?
Thanks for any more suggestions!
Paul Sinclair
> -Original Message-
> From: Dana Larose [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 6:25 PM
> To: [EMAIL PROTECTED]
> Subject: RE: 'ing FORM Field Names Problem
>
>
> One of the guys here came up with a hack to do this. Wrap an Evaluate
> around the expression, and that seemed to work for us in a similar
> situation. We'll not sure if this is clean ColdFusion or not,
> but it seems
> to get the job done.
>
> Here is a sample:
>
>
>
>
>
>
> Now tempcomment contains the value that full_name_3 from the previous page
> did. Assuming PersonsAttending is 3.
>
> Dana Larose
> Software Engineer
> Canadian Web Design & Consulting Inc.
>
> A: 701-281 McDermot Avenue (McDermot & King)
> P: 204-946-5155
> C: 204-228-0477
> F: 204-946-5156
> E: [EMAIL PROTECTED]
> W: http://www.cdnwebdesign.com
>
> > -Original Message-
> > From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 31, 2000 3:28 PM
> > To: [EMAIL PROTECTED]
> > Subject: 'ing FORM Field Names Problem
> >
> >
> > I've got a form that is dynamically created based on how many people are
> > being registered for an event. For example, if a person wants to
> > register 4
> > people, I use to create a form with fields for the entry of 4
> > peoples' names. I.e.:
> >
> >
> >
> >
> >
> > Person 1:
> >
> >
> >
> >
> >
> > > from="1"
> > to="#loopnumber#"
> > step="1">
> >
> > Next Person:
> >
> >
> >
> >
> >
> >
> >
> >
> > The effect of this is that the name of the form fields changes
> during each
> > step of the loop, such as:
> >
> > full_name_1 (where the index of "PersonsAttending" is 1)
> > full_name_2 (where the index of "PersonsAttending" is 2)
> > full_name_3 (where the index of "PersonsAttending" is 3)
> >
> > and so on.
> >
> > This works fine. But I'm having trouble in the template that
> receives the
> > information. I want to the registration info out. I can get the
> > first person's info fine, but for the fields where the field
> name has been
> > incremented during looping, I can't figure out how to capture
> the fields.
> >
> > The looks something like this:
> >
> >
> >
> >
> >
> > Registration Received for:
> >
> > #FORM.Full_Name#
> >
> >
> >
> > Other People Registered:
> >
> >
> >
> >
> >
> > #FORM.Full_Name#_#PersonsAttending#
> > ^^^
> >
> >
> >
> >
> > I've put "up carets" (^) under the spot where I'm having trouble. What I
> > need to do is concatenate "_#PersonsAttending#" to
> > #FORM.Full_Name#, but it
> > has to be inside the # signs. I can't figure out how to do it.
> I've tried
> > several variations and also tried using . Nothing seems to work.
> >
> > How do I get it so that the field from which the information is
> drawn gets
> > incremented up with each loop? In the case where 4 people are
> > registered, I
> > need to get it so that the portion winds up with loops for:
> >
> > #FORM.Full_Name_1#
> > #FORM.Full_Name_2#
> > #FORM.Full_Name_3#
> >
> > I can't figure out how to get the FORM field's name changed using the
> > . I'm sure it's something simple. But right now it is
> escaping me.
> >
> > Thanks for taking a look at this for me.
> >
> > Paul Sinclair
> >
> > -
Re: Problem Handling Sessions
yes you need to pass session.urltoken around between frames. >From the docs SESSIONTIMEOUT Optional. Enter the CreateTimeSpan function and the values you want in days, hours, minutes, and seconds, separated by commas to specify the lifespan of any session variables that are set. The default value is specified in the Variables page of the ColdFusion Administrator. This means that only the default timeout is set up in the CF administrator - Original Message - From: "Eron Cohen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 8:58 PM Subject: Problem Handling Sessions > Hi Folks, > > I have two questions about sessions. > > 1) I have an application that opens a pop-up javascript window with a form. > This on the javascript window submits itself back to the template that > opened it. It seemed to be working fine, but suddenly I am loosing my > session when the form is submitted. (Its changing to a new CFID and > CFTOKEN). The question is what could be causing me to loose the session in > this way and how do I fix this? Do I have to start passing URLTOKEN around? > > 2) What methods can I use to prolong the length of a session? I can't > change the timeout value because I am using an ISP. > > Thanks, > > Eron > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Problem Handling Sessions
Hi Folks, I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? 2) What methods can I use to prolong the length of a session? I can't change the timeout value because I am using an ISP. Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: login verification problem
At 11:15 PM 7/31/00 -0400, you wrote: >I might not follow this correctly, but loginname will ALWAYS be equal to >LoginName.. sort of like: > > >Al >A1webs > > > > Hey! You guys are thinking! That's not fair! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: login verification problem
I might not follow this correctly, but loginname will ALWAYS be equal to LoginName.. sort of like: Al A1webs > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: login verification problem
Try this. Query for the information WHERE (LoginName='#LoginName#' AND Password='#Password#') as you did below. You are attempting to gain access into a restricted area. You could also run a query for Loginname WHERE (LoginName='#LoginName#' AND Password='#Password#') and run the second query in the cfif statement. I don't see that it would be much more secure and it would be faster. At 07:36 PM 7/31/00 -0700, you wrote: >Hi, > >Here's my problem, I've got a login page, in which when you login, you are >presented with your specific details that you filled out etc... > >Now, the problem is, if I just put in whatever text for the login and the >password (obviously not stored in the database under that persons entry) >instead of getting an error, I get the output page but just no details. Not >something I want to have happen. > >Here's what I have for code; > >I need a way to check and see if the form entry is being checked against the >database entry. > > > >You are attempting to gain access into a restricted area. > > > > >You are attempting to gain access into a restricted area. > > > > >SELECT LoginName, > Password, > Name, > Birthday, > Age, > PictureName, > StreetAddress, > City, > Country, > Phone, > Email, > WebSite, > Question2, > Question3, > Question4, > Question7, > Question8, > Question9, > Question10, > Question11, > Question12, > Question13, > Question14, > Question15, > Question16, > Question17, > GeneralComments, > EmailList, > ICQ >FROM Grad94 >WHERE (LoginName='#LoginName#' AND Password='#Password#') > > >and of course, the HTML goes below here for the output etc...and its closed >off with the tag (not put in, just to save space), so the process >works however it'll process anything for a login but just won't output >anything when the login and password is wrong. > >Mark Smeets/stranger0/ICQ #1062196 > >"Mr. West, not every situation requires your patented approach of shoot >first, shoot later, shoot some more and then when everybody's dead try to >ask a question or two" - Wild Wild West > >Other Press Webslinger *New and Improved* >http://otherpress.douglas.bc.ca/ > >Official Splitting Adam Homepage >http://www.splittingadam.com/ > >Over the Wall Productions and Web Designs >http://www.solarcourt.com/ > > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >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/cf-talk@houseoffusion.com/ 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.
Re: login verification problem
For starters, this statement evaluates to true, even if you put total junk in the text fields: "" so as far as the template is concerned, the person logged in. So, it displays the info, just minus the actual details because the query will fail, because the junk in the text fields doesn't match anything in the database. Instead, how about something like this? SELECT LoginName, Password, Name, Birthday, Age, PictureName, StreetAddress, etc, etc, etc, ... FROM Grad94 WHERE LoginName='#Form.LoginName#' AND Password='#Form.Password#' Yay! You are logged in. Oops! Login failed. Make sure to scope all of your variables too. I.E. If you have a variable that was creadted through a form submission, stick 'Form' in front of it, etc. Todd - Original Message - From: "Mark Smeets" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 10:36 PM Subject: login verification problem > Hi, > > Here's my problem, I've got a login page, in which when you login, you are > presented with your specific details that you filled out etc... > > Now, the problem is, if I just put in whatever text for the login and the > password (obviously not stored in the database under that persons entry) > instead of getting an error, I get the output page but just no details. Not > something I want to have happen. > > Here's what I have for code; > > I need a way to check and see if the form entry is being checked against the > database entry. > > > > You are attempting to gain access into a restricted area. > > > > > You are attempting to gain access into a restricted area. > > > > > >SELECT LoginName, > Password, > Name, > Birthday, > Age, > PictureName, > StreetAddress, > City, > Country, > Phone, > Email, > WebSite, > Question2, > Question3, > Question4, > Question7, > Question8, > Question9, > Question10, > Question11, > Question12, > Question13, > Question14, > Question15, > Question16, > Question17, > GeneralComments, > EmailList, > ICQ >FROM Grad94 > WHERE (LoginName='#LoginName#' AND Password='#Password#') > > > and of course, the HTML goes below here for the output etc...and its closed > off with the tag (not put in, just to save space), so the process > works however it'll process anything for a login but just won't output > anything when the login and password is wrong. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
CF Apostrophe Bug
Bonnie wrote:
>
>you need to escape the apostrophes with
>
>
>
>then insert the new field into the query string. I've been fighting this
>problem for 6 months and this is the solution that seems to work best.
>Preservesinglequotes doesn't work in this instance.
>
>Hope this solves your problem
>
>Bonnie
>AGS
Bonnie,
This depends on your database. This technique doesn't work with SQL server
7. My suggestion is to
use a stored procedure with cfstoredproc. It takes care of the problem.
There is a definate bug in the way that CF handles apostrophes.
For example, in VBScript, if you want to insert data into SQL 7 that has an
apostrophe
in it, you simply change the variable to:
varName = Replace(varname, "'", "''")
The first apostrophe escapes the second one and it is entered correctly into
the database.
Try it in CF and it blows up.
varUnSafeAtAnySpeed=#varUnSafeAtAnySpeed#
INSERT INTO TEST (Name, Id) VALUES ('#varUnSafeAtAnySpeed#', 123)
Ok...so let's try another tact. We'll look to see if there is an apostrophe,
then insert one after it.
INSERT INTO TEST (Name, Id) VALUES ('#varSQLSafeName#', 123)
This doesn't blow it up, but it prints out wrong.
Ok, let's hard code it into the query and see what happens.
INSERT INTO TEST (Name, Id) VALUES ('O''Reilly Hard-Code', 123)
SELECT * FROM TEST Id WHERE Id = 123 ORDER BY CreateDate
This finally enters the correct data into the database and it displays
correctly.
But is it a bug in CF?
Cut and paste the following into a new template and test it out for
yourself:
Use this form to demonstrate the bug with the apostrophe's in CF
I found it while building a custom tag that makes insert queries.
I made a similar function in ASP this weekend and copied it to CF.
That's why I identified the bug. Thank Microshaft.
1) Start by building the two strings that you need for an update
statement
2) Grab the values from the form and get the form elements
3) Set the update statement
4) Update sting:
#attributes.update_string# #attributes.note#
5) Normally what we would do is to loop through the elements and add
them to a list.
However, since I first wrote this in ASP I didn't have that luxury. I
did it the ASP way.
6) You figger out how long the string is, then cut off the last comma.
7) Length of the trimmed string:
#iValuesFormSQLLength#
8) String before cutting off the last comma:
#BeforeMidValuesFormSQL#
9) String after cutting off the last comma:
#ValuesFormSQL#
Insert - With space
Insert - No Space
Brian W. Zaleski, DC, MS
Media Application Developer
roundpeg
www.roundpeg.com
1700 California Suite 260
San Francisco, CA. 94109
Ph. 415.437.3900
Fax 415.437.3904
Cell 415.265.2717
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
Re: Determining Datasources
The Tag Gallery has OracleDBInfo, which uses CFREGISTRY to get at the ODBC datasources on an NT server. -David On Mon, 31 Jul 2000 16:52:16 +0100 "Reynolds, Adam" <[EMAIL PROTECTED]> writes: > I'm in the process of writing an Oracle User Administration (add > delete > users, role management etc) sub-fusebox and need to know if it is > possible > to automatically determine the names of the available Oracle 8 > datasources > that the current server has. YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: 'ing FORM Field Names Problem
Dana, Thanks for your suggestion and code snippet. I'm still not getting it to work though. Here's what I've tried: Name = #FORM.tempcomment# When I run this, I get the same error I've been having: Error message follows- Error Diagnostic Information An error occurred while evaluating the expression: #FORM.tempcomment# Error resolving parameter FORM.TEMPCOMMENT The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. End Error Message- I can't figure out how to get CF to understand that where I have #FORM.tempcomment#, I want it to read the variable tempcomment so that it comes out as #FORM.full_name_1# (or #FORM.full_name_2#, etc.) How do I cram this thing down CF's throat? Thanks for any more suggestions! Paul Sinclair > -Original Message- > From: Dana Larose [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 6:25 PM > To: [EMAIL PROTECTED] > Subject: RE: 'ing FORM Field Names Problem > > > One of the guys here came up with a hack to do this. Wrap an Evaluate > around the expression, and that seemed to work for us in a similar > situation. We'll not sure if this is clean ColdFusion or not, > but it seems > to get the job done. > > Here is a sample: > > > > > > > Now tempcomment contains the value that full_name_3 from the previous page > did. Assuming PersonsAttending is 3. > > Dana Larose > Software Engineer > Canadian Web Design & Consulting Inc. > > A: 701-281 McDermot Avenue (McDermot & King) > P: 204-946-5155 > C: 204-228-0477 > F: 204-946-5156 > E: [EMAIL PROTECTED] > W: http://www.cdnwebdesign.com > > > -Original Message- > > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 31, 2000 3:28 PM > > To: [EMAIL PROTECTED] > > Subject: 'ing FORM Field Names Problem > > > > > > I've got a form that is dynamically created based on how many people are > > being registered for an event. For example, if a person wants to > > register 4 > > people, I use to create a form with fields for the entry of 4 > > peoples' names. I.e.: > > > > > > > > > > > > Person 1: > > > > > > > > > > > > > from="1" > > to="#loopnumber#" > > step="1"> > > > > Next Person: > > > > > > > > > > > > > > > > > > The effect of this is that the name of the form fields changes > during each > > step of the loop, such as: > > > > full_name_1 (where the index of "PersonsAttending" is 1) > > full_name_2 (where the index of "PersonsAttending" is 2) > > full_name_3 (where the index of "PersonsAttending" is 3) > > > > and so on. > > > > This works fine. But I'm having trouble in the template that > receives the > > information. I want to the registration info out. I can get the > > first person's info fine, but for the fields where the field > name has been > > incremented during looping, I can't figure out how to capture > the fields. > > > > The looks something like this: > > > > > > > > > > > > Registration Received for: > > > > #FORM.Full_Name# > > > > > > > > Other People Registered: > > > > > > > > > > > > #FORM.Full_Name#_#PersonsAttending# > > ^^^ > > > > > > > > > > I've put "up carets" (^) under the spot where I'm having trouble. What I > > need to do is concatenate "_#PersonsAttending#" to > > #FORM.Full_Name#, but it > > has to be inside the # signs. I can't figure out how to do it. > I've tried > > several variations and also tried using . Nothing seems to work. > > > > How do I get it so that the field from which the information is > drawn gets > > incremented up with each loop? In the case where 4 people are > > registered, I > > need to get it so that the portion winds up with loops for: > > > > #FORM.Full_Name_1# > > #FORM.Full_Name_2# > > #FORM.Full_Name_3# > > > > I can't figure out how to get the FORM field's name changed using the > > . I'm sure it's something simple. But right now it is > escaping me. > > > > Thanks for taking a look at this for me. > > > > Paul Sinclair > > > > -- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > 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/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
Re: Function for padding strings???
yea, i got after blowing up the RPG Sp a few times.. hahaha... Thanks guys - Original Message - From: "JustinMacCarthy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 10:36 AM Subject: Re: Function for padding strings??? > Look at > RJustify CJustify LJustify. RepeatString > > > ~Justin > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 31, 2000 3:18 PM > Subject: Function for padding strings??? > > > > > > > > Hello all, > >This might sound like a very stupid question, I need > > to pad a string with spaces, so that i can pass the value to > > a DB2 AS/400 Stored procedure. > > The SP has to get in format with no "," or any chars. > > Its kinda like a List with no special chars but the width of > > the list should be 300 and each part should be 15 chars long.. > > picky DB2/RPG SP. > > > > Ljustify is not working!!! > > Is there a fuction to pad strings?? > > > > Appretiate any comments > > > > thanks > > Joe > > > > > > - > > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > > The FREE way to access your mailbox via any web browser, anywhere! > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > 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/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
login verification problem
Hi, Here's my problem, I've got a login page, in which when you login, you are presented with your specific details that you filled out etc... Now, the problem is, if I just put in whatever text for the login and the password (obviously not stored in the database under that persons entry) instead of getting an error, I get the output page but just no details. Not something I want to have happen. Here's what I have for code; I need a way to check and see if the form entry is being checked against the database entry. You are attempting to gain access into a restricted area. You are attempting to gain access into a restricted area. SELECT LoginName, Password, Name, Birthday, Age, PictureName, StreetAddress, City, Country, Phone, Email, WebSite, Question2, Question3, Question4, Question7, Question8, Question9, Question10, Question11, Question12, Question13, Question14, Question15, Question16, Question17, GeneralComments, EmailList, ICQ FROM Grad94 WHERE (LoginName='#LoginName#' AND Password='#Password#') and of course, the HTML goes below here for the output etc...and its closed off with the tag (not put in, just to save space), so the process works however it'll process anything for a login but just won't output anything when the login and password is wrong. Mark Smeets/stranger0/ICQ #1062196 "Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two" - Wild Wild West Other Press Webslinger *New and Improved* http://otherpress.douglas.bc.ca/ Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Custom Tag for Date and Time
AS/400 uses Julian date. That could be why there is a way in how you have to
add those in there. Ask the RPG programmers what they put in for date and
time. I forgot all about that.
Bob Everland
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 10:09 PM
To: [EMAIL PROTECTED]
Subject: Re: Custom Tag for Date and Time
thanks, but still did not work. I am using db2-as/400 as backend. how do
i define a timestamp field since that is essentially what i would
probably want.
"Chapman, Katrina" wrote:
>
> Either use
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#',
> '#form.summary#','#url.assigned#','',#CreateODBCDateTime(Now())#)
>
>
> Or
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',Now())
>
>
> If you're using SQL server you can use
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#',
'#form.summary#','#url.assigned#','',GetDate())
>
>
> Or
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',sysdate)
>
>
> HTH,
> --K
>
> > -Original Message-
> > From: James Taavon [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, July 31, 2000 11:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Custom Tag for Date and Time
> >
> > Philip,
> >
> > I tried this...
> >
> >
> > insert into taavon.history
> > (lid,summary,completedby,assignedby,comptime)
> > values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
> >
> >
> >
> >
> > and got an error...
> >
> > ODBC Error Code = 22008 (Datetime field overflow)
> >
> > [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
> > of date,
> > time, or timestamp value not valid.
> >
> > The error occurred while processing an element with a general
> > identifier of (CFQUERY),
> > occupying document position (9:1) to (9:42).
> >
> > Any ideas?
> >
> >
> > Philip Arnold - ASP wrote:
> > >
> > > > Any one have a custom tag that retrieves both the DateFormat (Now())
> > and
> > > > TimeFormat (Now()) as one function that can be inserted into a
> > database?
> > >
> > > I assume you've got your field as a DateTime format - if not, then
> > change it
> > > to be DateTime
> > >
> > > Also, try to use the database native functions - Now() for Access and
> > > GetDate() for SQL Server - it'll be faster and cleaner than getting CF
> > to do
> > > the work
> > >
> > > If you really want to use CF to do it, then use
> > > #CreateODBCDateTime(Now())# - assuming you're talking to the database
> > ODBC
> > > and not OLE DB
> > >
> > > Try not to use DateFormat and TimeFormat into a format that "looks"
> > right
> > > for you - the database server may look at is as just some text and
> > produce
> > > an error - if you're fixed on the idea of using a set DateFormat, then
> > use
> > > one that isn't ambigious, like "d mmm ", that way, it can't be
> > > confused - DEFINITELY avoid formats like "mm/dd/" as some
databases
> > may
> > > interpret it as "dd/mm/yy" (depending on nationalisation)
> > >
> > > HTH
> > >
> > > Philip Arnold
> > > ASP Multimedia Limited
> > > T: +44 (0)20 8680 1133
> > >
> > > "Websites for the real world"
> > >
> > > **
> > > This email and any files transmitted with it are confidential and
> > > intended solely for the use of the individual or entity to whom they
> > > are addressed. If you have received this email in error please notify
> > > the system manager.
> > > **
> > >
> > >
>
> --
> >
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > 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/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/c
Re: Custom Tag for Date and Time
thanks, but still did not work. I am using db2-as/400 as backend. how do
i define a timestamp field since that is essentially what i would
probably want.
"Chapman, Katrina" wrote:
>
> Either use
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#',
> '#form.summary#','#url.assigned#','',#CreateODBCDateTime(Now())#)
>
>
> Or
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',Now())
>
>
> If you're using SQL server you can use
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',GetDate())
>
>
> Or
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',sysdate)
>
>
> HTH,
> --K
>
> > -Original Message-
> > From: James Taavon [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, July 31, 2000 11:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Custom Tag for Date and Time
> >
> > Philip,
> >
> > I tried this...
> >
> >
> > insert into taavon.history
> > (lid,summary,completedby,assignedby,comptime)
> > values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
> >
> >
> >
> >
> > and got an error...
> >
> > ODBC Error Code = 22008 (Datetime field overflow)
> >
> > [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
> > of date,
> > time, or timestamp value not valid.
> >
> > The error occurred while processing an element with a general
> > identifier of (CFQUERY),
> > occupying document position (9:1) to (9:42).
> >
> > Any ideas?
> >
> >
> > Philip Arnold - ASP wrote:
> > >
> > > > Any one have a custom tag that retrieves both the DateFormat (Now())
> > and
> > > > TimeFormat (Now()) as one function that can be inserted into a
> > database?
> > >
> > > I assume you've got your field as a DateTime format - if not, then
> > change it
> > > to be DateTime
> > >
> > > Also, try to use the database native functions - Now() for Access and
> > > GetDate() for SQL Server - it'll be faster and cleaner than getting CF
> > to do
> > > the work
> > >
> > > If you really want to use CF to do it, then use
> > > #CreateODBCDateTime(Now())# - assuming you're talking to the database
> > ODBC
> > > and not OLE DB
> > >
> > > Try not to use DateFormat and TimeFormat into a format that "looks"
> > right
> > > for you - the database server may look at is as just some text and
> > produce
> > > an error - if you're fixed on the idea of using a set DateFormat, then
> > use
> > > one that isn't ambigious, like "d mmm ", that way, it can't be
> > > confused - DEFINITELY avoid formats like "mm/dd/" as some databases
> > may
> > > interpret it as "dd/mm/yy" (depending on nationalisation)
> > >
> > > HTH
> > >
> > > Philip Arnold
> > > ASP Multimedia Limited
> > > T: +44 (0)20 8680 1133
> > >
> > > "Websites for the real world"
> > >
> > > **
> > > This email and any files transmitted with it are confidential and
> > > intended solely for the use of the individual or entity to whom they
> > > are addressed. If you have received this email in error please notify
> > > the system manager.
> > > **
> > >
> > >
> > --
> >
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > 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/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
Authenticating on Active Directory
First off, congrats to Michael Smith and everyone at CFUN-2K for a great conference! Secondly, has anyone found a way to authenticate passwords off of Windows 2000's Active Directory? We were able to set it up through advanced security on one of our servers, but not the other. Are there other methods? Or is there a big secret to setting it up through advanced security that we don't know about? :) Thanks! Norman Elton Information Technology College of William & Mary Williamsburg, VA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: cflock - BAH! and CF 4.51 question
In his case he felt that he was unable to turn off the "enforce strict attribute validation" setting, which is the server setting that handles exactly these circumstances. With this setting turned on, you will get errors in 4.x. With this setting turned off, the default, you will not get errors in 4.x. However, you will have issues in 4.5.1 if you don't have locks built in. At 08:56 PM 7/31/00 -0400, you wrote: >At 07:00 AM 7/15/00 , you wrote: > >Bud, (and anyone else) > >Was the conclusion here that the two versions are code incompatible with >regards to cflocking ?? i.e. i must have the same version of cf on our >test machines as our live machines ?? > >With that in mind, we have not yet installed the upgrade to 4.51 based upon >the problems we were seeing everyone else having.. Is 4.51 stable enough >for production environments ?? Are there any gotchas in moving from 4.01 to >4.51 we should know about in advance ?? > > > >Geesh. You'd think Allaire would give at least a LITTLE thought to > >backward compatibility. I've discovered that setting session, > >application variables, etc. MUST be set with a lock if CF 4.5 > >administration is set to make that mandatory. OK, I can live with > >that, but you MUST set the SCOPE in the cflock tag. But then if you > >try to use that template in 4.0x, scope is not understood and gives > >an error. What a crock. So now, everything I've developed I have to > >make 2 copies of, one with scope= and one without. And to develop > >with my CF 4.01 here at home, I have to develop everything without > >scope=, then add it in to all the cflock tags and upload the > >templates, then remove them all to do any future changes to the site, > >then add them back in to upload. What a mess! > > >Brian L. Wolfsohnhttp://www.cus.com >CUS Business Systems Ft.Lauderdale,FL >Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >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/cf-talk@houseoffusion.com/ 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.
cflock - BAH! and CF 4.51 question
At 07:00 AM 7/15/00 , you wrote: Bud, (and anyone else) Was the conclusion here that the two versions are code incompatible with regards to cflocking ?? i.e. i must have the same version of cf on our test machines as our live machines ?? With that in mind, we have not yet installed the upgrade to 4.51 based upon the problems we were seeing everyone else having.. Is 4.51 stable enough for production environments ?? Are there any gotchas in moving from 4.01 to 4.51 we should know about in advance ?? >Geesh. You'd think Allaire would give at least a LITTLE thought to >backward compatibility. I've discovered that setting session, >application variables, etc. MUST be set with a lock if CF 4.5 >administration is set to make that mandatory. OK, I can live with >that, but you MUST set the SCOPE in the cflock tag. But then if you >try to use that template in 4.0x, scope is not understood and gives >an error. What a crock. So now, everything I've developed I have to >make 2 copies of, one with scope= and one without. And to develop >with my CF 4.01 here at home, I have to develop everything without >scope=, then add it in to all the cflock tags and upload the >templates, then remove them all to do any future changes to the site, >then add them back in to upload. What a mess! Brian L. Wolfsohnhttp://www.cus.com CUS Business Systems Ft.Lauderdale,FL Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: mail archive of topics ?
http://www.mail-archive.com/cf-talk@houseoffusion.com/ first line of the footer. - Original Message - From: Marlon Isimeli <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 5:59 PM Subject: mail archive of topics ? > I think this is somewhere in the footers/heading/email > but missed out. > is there a location for the archives of all the mails that are sent to this > cf-talk list ? > > > THANKS in advance. > ++ > Mahlon Isimeli > Information Technology and Computing Services > Open VMS Support Team > Database Technical Support Team > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Re: Newbie Question on Tables and CF
Thanks for the tip. Richard - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 30, 2000 8:23 AM Subject: RE: Newbie Question on Tables and CF > > I've been searching on info on how to create a multiple column table = > > from one column of data. > > > > What I want to be able to do is create a table like so: > > > > AdamChris > > Bob Dan > > > > But the code I found outputs like this: > > > > AdamBob > > ChrisDan > > > > How do I do this? I'm thinking that I might have to two tables. If > > this is the case, how do I go about doing that? > > Why not just put a after the first entry, and hold as many as you want > in one cell (valign="top") and move to the next cell when done > > Instead of having 4 cells, have 2. > > Philip Arnold > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > > "Websites for the real world" > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ** > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Re: Putting CF into RT files (smil files)
Hi Andrea. We have been working a little with smil files here. I haven't seen much out there on those two subjects, but I found a couple of links below. Hopefuly it helps. http://agassiz.prognet.com/devzone/solutions/software/multimedia.html or http://www.webdeveloper.com/advhtml/advhtml_tutorial_SMIL_tools.html I'm also interesting in learning more about what you are developing. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] - Original Message - From: "Andrea Wasik(CancerSource)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 2:06 PM Subject: Putting CF into RT files (smil files) > I am trying to find info on using CF in RealText files that are being called > by smil files. Can't seem to find any good documentation on this. Can anyone > point me in the right direction? If I just stick the CF in there it breaks > the page... > > Andrea > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE: Thanks CF Community!
> CFUN-2k was last weekend. I want to thank everyone in the CF community > (speakers, volunteers, attendees, CFUG managers, CF Family Feud player > etc) for helping out - without you it would not have been possible! > Thanks! > - Michael Smith, TeraTech http://www.cfconf.org/ >MDCFUG http://www.cfug-md.org/ Congratulations Michael on a very well organized, informative and enjoyable conference. Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Oracle and the & sign
Hi All, 1) Can anyone using Oracle tell me how to get around referencing the & symbol in oracle? I have an SQL script that is designed for users to run in either Query Analyzer (SQL server) using ISQL (Sybase) like below: INSERT INTO documents (doc_id, doc_text) VALUES (1, "© Ektron 1999 & 2000, etc...") Apparently whereever there is an &(ampersand) oracle expects a value and prompts please enter value. 2) Does the Oracle ODBC driver prevent this from happening? The strings I am dealing with contain formatted HTML and there will be a lot of & symbols. Thanks, Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Quirky Date Bug: MM/YY
Try something like this? REReplaceNoCase(ccdate,"/","/28/"): #REReplaceNoCase(ccdate,"/","/28/")# - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Hondo Burney" <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 7:30 PM Subject: Re: Quirky Date Bug: MM/YY > What CF is doing is interpretting 08/03 as August 3rd of the current year. > It automatically assumes that a date that looks like month/day is in the > current year. When you enter something like 08/32, it gets "smart" and > says that if it can't interpret it as month/day, then maybe it's supposed > to be month/year. I believe it actually would interpret 08/32 as Aug 1st, > 1932. > > I never try to interpret credit card expirations as dates, per se. I > usually use two fields on a form and then store it as a simple string. > > Jim > > > -Original Message- > From: Hondo Burney <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Monday, July 31, 2000 5:11 PM > Subject: Quirky Date Bug: MM/YY > > > >Sorry if this is a repost, but I looked in the archives for references to > >this bug and couldn't find any. We have customers who are inputing their > >Credit Card information into a form field. For reasons that are beyond my > >control, we can't give them a drop down to select their month and year of > >expiration. So invariably people input their data in the traditional > credit > >card date format of 08/02, or MM/YY. the problem is that Cold Fusion > >refuses to recognize this format, instead when I try and format the data, > >CF interprets the /01 as the day, not they year. So I get passed a form > >field with a string in it that is something like 08/02 > > > > > > > > > >I have tried LSParseDateTime , CreateODBCDate, and everything else I can > >think of. No matter what I do, if the form field contains data in the > form > >of 08/02, CF screws up and interprets the date as 08/00. The wierd quirk > is > >that if the year is over 31, it works, but if it's under 32, it reads it > as > >2000. Also, it doesn't matter if I change up the dateformat to > MM/DD/ > >or anything else. It still misinterprets the YY part. > > > >I would appreciate any insight into this wierd bug. I know I can just > write > >a little parser to fix the problem, but I just can't believe that CF > can't > >handle such a common credit card convention. > > > > > >---Hondo--- > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Re: Quirky Date Bug: MM/YY
What CF is doing is interpretting 08/03 as August 3rd of the current year. It automatically assumes that a date that looks like month/day is in the current year. When you enter something like 08/32, it gets "smart" and says that if it can't interpret it as month/day, then maybe it's supposed to be month/year. I believe it actually would interpret 08/32 as Aug 1st, 1932. I never try to interpret credit card expirations as dates, per se. I usually use two fields on a form and then store it as a simple string. Jim -Original Message- From: Hondo Burney <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, July 31, 2000 5:11 PM Subject: Quirky Date Bug: MM/YY >Sorry if this is a repost, but I looked in the archives for references to >this bug and couldn't find any. We have customers who are inputing their >Credit Card information into a form field. For reasons that are beyond my >control, we can't give them a drop down to select their month and year of >expiration. So invariably people input their data in the traditional credit >card date format of 08/02, or MM/YY. the problem is that Cold Fusion >refuses to recognize this format, instead when I try and format the data, >CF interprets the /01 as the day, not they year. So I get passed a form >field with a string in it that is something like 08/02 > > > > >I have tried LSParseDateTime , CreateODBCDate, and everything else I can >think of. No matter what I do, if the form field contains data in the form >of 08/02, CF screws up and interprets the date as 08/00. The wierd quirk is >that if the year is over 31, it works, but if it's under 32, it reads it as >2000. Also, it doesn't matter if I change up the dateformat to MM/DD/ >or anything else. It still misinterprets the YY part. > >I would appreciate any insight into this wierd bug. I know I can just write >a little parser to fix the problem, but I just can't believe that CF can't >handle such a common credit card convention. > > >---Hondo--- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: OT: what is better varchar or char
At 01:52 PM 7/31/00 -0500, you wrote: >I was told that char is better than varchar. Is this right? > >I am going to have fields that are set to be either 25 50 100 or 150 >characters long. Is there a reason any of these fields should be char or >varchar? I have allways used varchar but I would like to know what is best. > >Feel free to respond directly to me since it is OT ;-) Um, no. This is probably a common question. I wanted to know this once and this is where I got my answer. I've heard that varchar is better because the field lengths varies to the size of the contents. With char there is a set length and all extra space is taken up with spaces. That means that with varchar you won't have to be so fond of the Trim function and your db will probably end up smaller. You can still put a max length on the field, but the minimum length does not equal the max length. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Quirky Date Bug: MM/YY
Sorry if this is a repost, but I looked in the archives for references to this bug and couldn't find any. We have customers who are inputing their Credit Card information into a form field. For reasons that are beyond my control, we can't give them a drop down to select their month and year of expiration. So invariably people input their data in the traditional credit card date format of 08/02, or MM/YY. the problem is that Cold Fusion refuses to recognize this format, instead when I try and format the data, CF interprets the /01 as the day, not they year. So I get passed a form field with a string in it that is something like 08/02 I have tried LSParseDateTime , CreateODBCDate, and everything else I can think of. No matter what I do, if the form field contains data in the form of 08/02, CF screws up and interprets the date as 08/00. The wierd quirk is that if the year is over 31, it works, but if it's under 32, it reads it as 2000. Also, it doesn't matter if I change up the dateformat to MM/DD/ or anything else. It still misinterprets the YY part. I would appreciate any insight into this wierd bug. I know I can just write a little parser to fix the problem, but I just can't believe that CF can't handle such a common credit card convention. ---Hondo--- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Verity search with periods
I am trying to do a verity search on a collection I have created from various fields in a database. The search seems to work fine unless someone searches for something with a period in it and then only if the period is in the middle of the search string. An example would be 'The Talented Mr. Ripley'. If someone searches for 'Talented Mr.' then it works fine and the proper item comes back. It is when someone searches for 'Mr. Ripley' that the search comes back with no records found. Is the period some kind of wild card or it something else like that going on here? Thanks, Mike -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
ACESS to Oracle
Is there some easy, automated method for copying/converting an ACCESS database to an Oracle database. One can always do it the hard way (recreate the schema, output as a delimited text file, load it back into oracle, etc. etc.) but ... TNX. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: 'ing FORM Field Names Problem
One of the guys here came up with a hack to do this. Wrap an Evaluate around the expression, and that seemed to work for us in a similar situation. We'll not sure if this is clean ColdFusion or not, but it seems to get the job done. Here is a sample: Now tempcomment contains the value that full_name_3 from the previous page did. Assuming PersonsAttending is 3. Dana Larose Software Engineer Canadian Web Design & Consulting Inc. A: 701-281 McDermot Avenue (McDermot & King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com > -Original Message- > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 3:28 PM > To: [EMAIL PROTECTED] > Subject: 'ing FORM Field Names Problem > > > I've got a form that is dynamically created based on how many people are > being registered for an event. For example, if a person wants to > register 4 > people, I use to create a form with fields for the entry of 4 > peoples' names. I.e.: > > > > > > Person 1: > > > > > > from="1" > to="#loopnumber#" > step="1"> > > Next Person: > > > > > > > > > The effect of this is that the name of the form fields changes during each > step of the loop, such as: > > full_name_1 (where the index of "PersonsAttending" is 1) > full_name_2 (where the index of "PersonsAttending" is 2) > full_name_3 (where the index of "PersonsAttending" is 3) > > and so on. > > This works fine. But I'm having trouble in the template that receives the > information. I want to the registration info out. I can get the > first person's info fine, but for the fields where the field name has been > incremented during looping, I can't figure out how to capture the fields. > > The looks something like this: > > > > > > Registration Received for: > > #FORM.Full_Name# > > > > Other People Registered: > > > > > > #FORM.Full_Name#_#PersonsAttending# > ^^^ > > > > > I've put "up carets" (^) under the spot where I'm having trouble. What I > need to do is concatenate "_#PersonsAttending#" to > #FORM.Full_Name#, but it > has to be inside the # signs. I can't figure out how to do it. I've tried > several variations and also tried using . Nothing seems to work. > > How do I get it so that the field from which the information is drawn gets > incremented up with each loop? In the case where 4 people are > registered, I > need to get it so that the portion winds up with loops for: > > #FORM.Full_Name_1# > #FORM.Full_Name_2# > #FORM.Full_Name_3# > > I can't figure out how to get the FORM field's name changed using the > . I'm sure it's something simple. But right now it is escaping me. > > Thanks for taking a look at this for me. > > Paul Sinclair > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE: what is better varchar or char
>I was told that char is better than varchar. Is this right? >I am going to have fields that are set to be either 25 50 100 or 150 >characters long. Is there a reason any of these fields should be char or >varchar? I have always used varchar but I would like to know what is best. As in most things, "Better" is a relative judgment. The primary difference is that CHAR fields are right padded with spaces which can make them difficult to work with if your data is not all of the same size (say an SKU that is always a certain number of characters in length). VARCHAR fields store variable length character data without padding the data with white space. In my experience, the data stored in VARCHAR fields is easier to work with because I find I'm using the TRIM() function often with CHAR fields to eliminate the excess spaces. One other key difference in terms of functionality is that the CHAR data type does not allow null values. If you create a field in a table as CHAR with nulls allowed, SQL Server will just create that field as VARCHAR and you'll never know the difference except if you expect the data to be padded. Since the CHAR data type has less overhead associated with it, it is slightly faster than the VARCHAR data type. However, this is very minimal performance gain, one that is completely negated if you find yourself using the TRIM() function on the ColdFusion side. >Feel free to respond directly to me since it is OT ;-) Actually, I think this is pretty right on. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
mail archive of topics ?
I think this is somewhere in the footers/heading/email but missed out. is there a location for the archives of all the mails that are sent to this cf-talk list ? THANKS in advance. ++ Mahlon Isimeli Information Technology and Computing Services Open VMS Support Team Database Technical Support Team -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Frames ,Client Variables, and no cookies
are you passing it (#session.urltoken# or #urltoken#) in the frame src? eg., To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 12:49 PM Subject: Frames ,Client Variables, and no cookies > I am having problems using client variables or session variables for > that matter when I am in a framed enviroment. I know I have to append the > client.token(I forget exactly what it is) at the end of the url. When I do > this each page's CFID and CFTOKEN are different. Has anyone else had this > problem? Can anyone help me? > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE: Custom Tag for Date and Time
Either use
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#',
'#form.summary#','#url.assigned#','',#CreateODBCDateTime(Now())#)
Or
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#', '#form.summary#','#url.assigned#','',Now())
If you're using SQL server you can use
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#', '#form.summary#','#url.assigned#','',GetDate())
Or
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#', '#form.summary#','#url.assigned#','',sysdate)
HTH,
--K
> -Original Message-
> From: James Taavon [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Custom Tag for Date and Time
>
> Philip,
>
> I tried this...
>
>
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
>
>
>
>
> and got an error...
>
> ODBC Error Code = 22008 (Datetime field overflow)
>
> [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
> of date,
> time, or timestamp value not valid.
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY),
> occupying document position (9:1) to (9:42).
>
> Any ideas?
>
>
> Philip Arnold - ASP wrote:
> >
> > > Any one have a custom tag that retrieves both the DateFormat (Now())
> and
> > > TimeFormat (Now()) as one function that can be inserted into a
> database?
> >
> > I assume you've got your field as a DateTime format - if not, then
> change it
> > to be DateTime
> >
> > Also, try to use the database native functions - Now() for Access and
> > GetDate() for SQL Server - it'll be faster and cleaner than getting CF
> to do
> > the work
> >
> > If you really want to use CF to do it, then use
> > #CreateODBCDateTime(Now())# - assuming you're talking to the database
> ODBC
> > and not OLE DB
> >
> > Try not to use DateFormat and TimeFormat into a format that "looks"
> right
> > for you - the database server may look at is as just some text and
> produce
> > an error - if you're fixed on the idea of using a set DateFormat, then
> use
> > one that isn't ambigious, like "d mmm ", that way, it can't be
> > confused - DEFINITELY avoid formats like "mm/dd/" as some databases
> may
> > interpret it as "dd/mm/yy" (depending on nationalisation)
> >
> > HTH
> >
> > Philip Arnold
> > ASP Multimedia Limited
> > T: +44 (0)20 8680 1133
> >
> > "Websites for the real world"
> >
> > **
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager.
> > **
> >
> >
> --
>
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
CF 4.5.1 on Solaris 8
I just got this new sun box and I am trying to get ColdFusion to run on it. I am running apache 1.3.12 but I keep getting this error about the LoadModule Here is the error Invalid command 'LoadModule', perhaps mis-spelled or defined by a module not included in the server configuration Has anybody else seen this? How did you fix it? -- Nick McClure[EMAIL PROTECTED] Technical Director 606.245.9656 squareFish Mediawww.squareFish.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Insert date and time into database
Removing the quotes did not work. I do not deal with adding dates to a database to much, but when I do, it takes me a while to figure it out. I went with plan B below. It works. Fine for what I need. update hitclear set cleardate = '#dateclear#', cleartime = '#timeclear#' where table_id = 'reeldemand' thanks Jacob At 04:12 PM 7/31/00 -0400, you wrote: > > >update hitclear >where table_id = reeldemand >set cleardate = '#now#' > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
OT: appropriate SQL 7 licensing for CF website
Hi All, I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for something like $30K ... is there something cheaper than that -- what do most people do for their web sites?? THX! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Putting CF into RT files (smil files)
I am trying to find info on using CF in RealText files that are being called by smil files. Can't seem to find any good documentation on this. Can anyone point me in the right direction? If I just stick the CF in there it breaks the page... Andrea -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Changing FuseAction (Action) using Javascript
Hi, There was a Javascript function for changing the FuseAction during submit a few days ago. Can anybody send this function again please. Thanks Nader = Nader Molavi Allaire Certified ColdFusion 4.5 Developer Palm, Inc. Email: [EMAIL PROTECTED] ICQ #: 3478405 __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Insert date and time into database
First of all you have your SQL statement in the wrong order
It should be
UPDATE
SET
WHERE
Secondly now in cf is #Now()# not #now#. That is of course if you haven't
set a variable higher up in your template called now. If you do have one I
would suggest renaming it to something else to avoid confusion.
--K
> -Original Message-
> From: Jacob [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Insert date and time into database
>
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
>
>
> update hitclear
> where table_id = 'reeldemand'
> set cleardate = '#now#'
>
>
> But, I get the following error:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
> keyword 'where'.
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> Data Source = "hits"
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> The error occurred while processing an element with a general identifier
> of
> (CFQUERY), occupying document position (7:1) to (7:44) in the template
> file
> D:\html\counter.htm
> The specific sequence of files included or processed is:
> D:\HTML\COUNTER.HTM .
> Date/Time: 07/31/00 11:12:22
>
> I did have it working, but it was almost 8 lines of coding to set the date
>
> and time. I Would like to shorten the code to speed up the template.
>
> Any suggestions?
>
> Thanks
> Jacob
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
Re: Textareas
> The maximum number of characters you can put in a memo field is 65500 > characters(ish), so you won't be able to put any more than that in without > up sizing to something like SQL Server. While I don't recall the specifics, be sure to check out the differences between Netscape and IE. I seem to recall Netscape having a problem with truncating long data when bringing it back into Textarea fields for editing during system tests on a site. Roughly 65k was the limit for each on submitting data and I encountered no problems. Ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: CV/Resume Project Descriptions
> Hello - I'm updating my resume since I've become familiar with > ColdFusion. I have worked independently on two projects for my > university - one for storing, retrieving and updating survey data from > faculty members, and a second project for the Students' Union, a message > board of sorts where students can post textbooks for sale or trade and > have them sorted by programme, course, etc. Sorry for rambling here, > but I'm curious as to how I describe these two projects on my Resume for > prospective employers? I'm sure some of you out there are involved in > HR with your organization and can tell me what you specifically look > for. MANY THANKS!! It's really appreciated. > > -Jamie I think it is far more important to convey what level of understanding you have of the many technologies involved in web application development. Don't just throw around the latest list of buzzwords without demonstrating how you understand the technology. Things like: used session variables to maintain user login state information in faculty survey application administration or designed and implemented SQLServer database for student message board system > Bachelor of Information Systems student, St. Francis Xavier University PS: how is the weather in Antigonish ;-) Cheers, Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Insert date and time into database
that the quotes out of the query for the time...
i use something like
update hitclear
set cleardate = #CreateODBCDateTime(Now())#
where table_id = 'reeldemand'
- Original Message -
From: "Jacob" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 11:34 AM
Subject: Insert date and time into database
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
>
>
> update hitclear
> where table_id = 'reeldemand'
> set cleardate = '#now#'
>
>
> But, I get the following error:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
> keyword 'where'.
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> Data Source = "hits"
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (7:1) to (7:44) in the template
file
> D:\html\counter.htm
> The specific sequence of files included or processed is:
> D:\HTML\COUNTER.HTM .
> Date/Time: 07/31/00 11:12:22
>
> I did have it working, but it was almost 8 lines of coding to set the date
> and time. I Would like to shorten the code to speed up the template.
>
> Any suggestions?
>
> Thanks
> Jacob
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
RE: Textareas
You may already done this but...go into Access and open your table in Design view. For field size specify 255 (it as high as you can go). Robert O. Web Admin HW Wilson >-Original Message- >From: Jeff Epstein [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 31, 2000 12:59 PM >To: '[EMAIL PROTECTED]' >Subject: RE: Textareas > > >Are you using Netscape to view the fields? Try IE--Netscape will cut off >text in text boxes at much less than the 64K limit inherent in Cold Fusion. >I don't know of any work around for that. > > > >Jeff Epstein >Web Producer > > > >-Original Message- >From: Jamie Symonds [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 31, 2000 12:53 PM >To: [EMAIL PROTECTED] >Subject: Textareas > > >Hello again - Question regarding TEXTAREAs - I am using textareas to >submit data to my memo field in an Access database - it seems as though >there's a limit on how much info I can submit through them - any >suggestions, ideas, or comments? I would like to be able to submit very >large chunks of text and not have them cut-off half-way through. Thanks >everyone. You all rock. > >Jamie > > >--- >- >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >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/cf-talk@houseoffusion.com/ >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/cf-talk@houseoffusion.com/ 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.
RE: [Error message] %$@&*#@ Netscape
We've had this problem also and its because Netscape 4.04 has trouble with cookies and session variables need cookies to keep track of the user. I got around this by passing the variable session.URLToken over the url. For example http://www.mysite.com/page.cfm?#session.URLToken# I can't remember if you need the ?. Hope this helps. __ Carlos Vazquez Web Administrator www.locateadoc.com www.mojointeractive.com > -Original Message- > From: Todd Ashworth [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 2:50 PM > To: [EMAIL PROTECTED] > Subject: [Error message] %$@&*#@ Netscape > > > I'm getting this error message: > > -8<-- snip --->8--- > Error Diagnostic Information > > An Error occurred while evaluating the expression > #Session.cart_arr(i).comments# > Error near line 240, column 97 > > The element at position 4 in dimension 1 of object > "Session.cart_arr" cannot > be found. The object has elements in positions 1 through 3. > Please modify > the index expression. > -8<-- snip --->8--- > > I understand what it's trying to say, but what I don't understand is why > this is *only* happening with Netscape 4.04. It works fine in > Netscape 4.08 > and all 4.x and 5.x versions of IE. Upgrading the browser isn't > an option, > since this is a 'local' internet app and 1/2 the population in the area is > using the 4.04 version. Anyone have a clue? > > Todd Ashworth > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
'ing FORM Field Names Problem
I've got a form that is dynamically created based on how many people are being registered for an event. For example, if a person wants to register 4 people, I use to create a form with fields for the entry of 4 peoples' names. I.e.: Person 1: Next Person: The effect of this is that the name of the form fields changes during each step of the loop, such as: full_name_1 (where the index of "PersonsAttending" is 1) full_name_2 (where the index of "PersonsAttending" is 2) full_name_3 (where the index of "PersonsAttending" is 3) and so on. This works fine. But I'm having trouble in the template that receives the information. I want to the registration info out. I can get the first person's info fine, but for the fields where the field name has been incremented during looping, I can't figure out how to capture the fields. The looks something like this: Registration Received for: #FORM.Full_Name# Other People Registered: #FORM.Full_Name#_#PersonsAttending# ^^^ I've put "up carets" (^) under the spot where I'm having trouble. What I need to do is concatenate "_#PersonsAttending#" to #FORM.Full_Name#, but it has to be inside the # signs. I can't figure out how to do it. I've tried several variations and also tried using . Nothing seems to work. How do I get it so that the field from which the information is drawn gets incremented up with each loop? In the case where 4 people are registered, I need to get it so that the portion winds up with loops for: #FORM.Full_Name_1# #FORM.Full_Name_2# #FORM.Full_Name_3# I can't figure out how to get the FORM field's name changed using the . I'm sure it's something simple. But right now it is escaping me. Thanks for taking a look at this for me. Paul Sinclair -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Insert date and time into database
If table_id is an integer, take away the quotes ...
update hitclear
where table_id = reeldemand
set cleardate = '#now#'
Also, I'm not sure if you can use now as the variable name is your CFSET
statement. If you can't, I'm sure someone on this list will speak up.
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 2:34 PM
To: [EMAIL PROTECTED]
Subject: Insert date and time into database
I want to insert the date and time into a sql database. Here is want I am
trying to do:
update hitclear
where table_id = 'reeldemand'
set cleardate = '#now#'
But, I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'where'.
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
Data Source = "hits"
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (7:1) to (7:44) in the template file
D:\html\counter.htm
The specific sequence of files included or processed is:
D:\HTML\COUNTER.HTM .
Date/Time: 07/31/00 11:12:22
I did have it working, but it was almost 8 lines of coding to set the date
and time. I Would like to shorten the code to speed up the template.
Any suggestions?
Thanks
Jacob
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
RE: Insert date and time into database
the syntax is
UPDATE hitclear
SET cleardate = '#now()#'
WHERE table_id = 'reeldemand'
you have the set and where clauses reversed.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 2:34 PM
To: [EMAIL PROTECTED]
Subject: Insert date and time into database
I want to insert the date and time into a sql database. Here is want I am
trying to do:
update hitclear
where table_id = 'reeldemand'
set cleardate = '#now#'
But, I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'where'.
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
Data Source = "hits"
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (7:1) to (7:44) in the template file
D:\html\counter.htm
The specific sequence of files included or processed is:
D:\HTML\COUNTER.HTM .
Date/Time: 07/31/00 11:12:22
I did have it working, but it was almost 8 lines of coding to set the date
and time. I Would like to shorten the code to speed up the template.
Any suggestions?
Thanks
Jacob
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
Re: Insert date and time into database
that is because you should put the WHERE clause at the end. You define what
you want to do, then define on which records you want to do it.
update hitclear
set cleardate = '#now#'
where table_id = 'reeldemand'
- Original Message -
From: Jacob <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 2:34 PM
Subject: Insert date and time into database
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
>
>
> update hitclear
> where table_id = 'reeldemand'
> set cleardate = '#now#'
>
>
> But, I get the following error:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
> keyword 'where'.
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> Data Source = "hits"
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (7:1) to (7:44) in the template
file
> D:\html\counter.htm
> The specific sequence of files included or processed is:
> D:\HTML\COUNTER.HTM .
> Date/Time: 07/31/00 11:12:22
>
> I did have it working, but it was almost 8 lines of coding to set the date
> and time. I Would like to shorten the code to speed up the template.
>
> Any suggestions?
>
> Thanks
> Jacob
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
Frames ,Client Variables, and no cookies
I am having problems using client variables or session variables for that matter when I am in a framed enviroment. I know I have to append the client.token(I forget exactly what it is) at the end of the url. When I do this each page's CFID and CFTOKEN are different. Has anyone else had this problem? Can anyone help me? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: congratulations Daddy Camden
Congrats > -Original Message- > From: Jennifer [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 12:55 PM > To: [EMAIL PROTECTED] > Subject: congratulations Daddy Camden > > > I don't know if you guys have been informed yet, but congratulations to > Raymond Camden on the adoption of his perfect baby boy. He's finally here! > > http://www.camdenfamily.com/jacob/arrival/ > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
(Admin) New List
I've started up a separate list called CF-Server for discussion of server related issues. This includes: Hardware Installation Administration Server Security Best Practices Hosting etc. This does not mean that these topics can not be spoken about on CF-Talk. Only that there is now a preferred location for it. Enjoy. Michael Dinowitz List(s) Admin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Thanks CF Community!
CFUN-2k was last weekend. I want to thank everyone in the CF community (speakers, volunteers, attendees, CFUG managers, CF Family Feud player etc) for helping out - without you it would not have been possible! Thanks! - Michael Smith, TeraTech http://www.cfconf.org/ MDCFUG http://www.cfug-md.org/ -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting 100 Park Ave Ste 360, Rockville MD 20850 USA Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185 BBS:301-762-8184 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
OT: what is better varchar or char
This is a multi-part message in MIME format. --=_NextPart_000_001B_01BFFAF6.7FFB2ED0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was told that char is better than varchar. Is this right? =20 I am going to have fields that are set to be either 25 50 100 or 150 = characters long. Is there a reason any of these fields should be char or = varchar? I have allways used varchar but I would like to know what is = best. =20 Feel free to respond directly to me since it is OT ;-) Art =20 =20 --=_NextPart_000_001B_01BFFAF6.7FFB2ED0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was told that char is better than = varchar. Is=20 this right? I am going to have fields that are set to be = either=20 25 50 100 or 150 characters long. Is there a reason any of these = fields=20 should be char or varchar? I have allways used varchar but I would like = to know=20 what is best. Feel free to respond directly to me since it = is OT=20 ;-) Art --=_NextPart_000_001B_01BFFAF6.7FFB2ED0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
OT: what is better varchar or char
I was told that char is better than varchar. Is this right? I am going to have fields that are set to be either 25 50 100 or 150 characters long. Is there a reason any of these fields should be char or varchar? I have allways used varchar but I would like to know what is best. Feel free to respond directly to me since it is OT ;-) Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
[Error message] %$@&*#@ Netscape
I'm getting this error message: -8<-- snip --->8--- Error Diagnostic Information An Error occurred while evaluating the expression #Session.cart_arr(i).comments# Error near line 240, column 97 The element at position 4 in dimension 1 of object "Session.cart_arr" cannot be found. The object has elements in positions 1 through 3. Please modify the index expression. -8<-- snip --->8--- I understand what it's trying to say, but what I don't understand is why this is *only* happening with Netscape 4.04. It works fine in Netscape 4.08 and all 4.x and 5.x versions of IE. Upgrading the browser isn't an option, since this is a 'local' internet app and 1/2 the population in the area is using the 4.04 version. Anyone have a clue? Todd Ashworth -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Insert date and time into database
I want to insert the date and time into a sql database. Here is want I am
trying to do:
update hitclear
where table_id = 'reeldemand'
set cleardate = '#now#'
But, I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'where'.
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
Data Source = "hits"
SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
'2000-07-31 11:12:22'}'"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (7:1) to (7:44) in the template file
D:\html\counter.htm
The specific sequence of files included or processed is:
D:\HTML\COUNTER.HTM .
Date/Time: 07/31/00 11:12:22
I did have it working, but it was almost 8 lines of coding to set the date
and time. I Would like to shorten the code to speed up the template.
Any suggestions?
Thanks
Jacob
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
RE: Textareas
> Hello again - Question regarding TEXTAREAs - I am using textareas to > submit data to my memo field in an Access database - it seems as though > there's a limit on how much info I can submit through them - any > suggestions, ideas, or comments? I would like to be able to submit very > large chunks of text and not have them cut-off half-way through. Thanks > everyone. You all rock. If you're not running CF4.5, ODBC has a 64k limit on the text it can send to one field - if you're using 4.5, then you can set the limit to whatever you want (or say "no limit", but this does slow CF down) If you're still using CF4, then you're stuck with the 64k limit (per field) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Javascript / DHTML List
-Original Message- From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: OT: Javascript / DHTML List Hi, This is off topic... Can anyone recommend a good Javascript / DHTML list for advanced developers? Thanks, Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Time add
> Is there a function to do the adding with time. (like DateAdd)
> i want to create a output with the hours of the day by the half hour.
>
> meaning:
> 8:00
> 8:30
> 9:00
> 9:30
>
> does anyone know of a way to do this??
Surprisingly, DateAdd does this... it allows hours (h), Minutes (n) and
Seconds (s)
So, you could do;
#TimeFormat(DateAdd("n",Evaluate(30*variables.i),variables.myStart
Time)#
This would produce what you're looking for
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
RE: Date subtraction
> Is there a way to substract days from a date value similar to the =
> dateAdd function in CF. I looked through the manual and I am not seeing =
> anything. What I am trying to do is set up date values 2 weeks before =
> and 2weeks after todays date.
Quoting from the CF Documentation for DateAdd();
"Number of units of datepart to add to date (positive to get dates in the
future or negative to get dates in the past)."
So, if you want to have a date 2 weeks in advance;
DateAdd("d",14,Now())
And 2 weeks back;
DateAdd("d",-14,Now())
If you're saying "Similar to the dateAdd function in CF", where else would you want to
handle the dates?
If you're doing it at database level, we need to know which database engine you're
using before we can offer advice.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
RE: Time add
I must appologize in advance for the format. I have just been put back onto Outlook 97 and haven't found the formating tools yet. That being said. That will only get one iteration of the time. Try this #display# --K > -Original Message- > From: Steve Martin [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 10:07 AM > To: [EMAIL PROTECTED] > Subject: RE: Time add > > Eli, > Try something like this: > > #Now()# > #CreateODBCDateTime(Evaluate(Now()+CreateTimeSpan(0,0,30,0)))# > > > The first line outputs the current d/t and the second line demonstrates > that > half an hour has been added to it by way of the CreateTimeSpan function. > > Steve > > > -Original Message- > > From: Eli Shechter [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 31, 2000 16:49 > > To: [EMAIL PROTECTED] > > Subject: Time add > > > > > > Is there a function to do the adding with time. (like DateAdd) > > i want to create a output with the hours of the day by the half hour. > > > > meaning: > > > > 8:00 > > 8:30 > > 9:00 > > 9:30 > > > > does anyone know of a way to do this?? > > > > Thanx > > -Eli- > > > > -- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > 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/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
Re: Custom Tag for Date and Time
Philip,
I tried this...
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
and got an error...
ODBC Error Code = 22008 (Datetime field overflow)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
of date,
time, or timestamp value not valid.
The error occurred while processing an element with a general
identifier of (CFQUERY),
occupying document position (9:1) to (9:42).
Any ideas?
Philip Arnold - ASP wrote:
>
> > Any one have a custom tag that retrieves both the DateFormat (Now()) and
> > TimeFormat (Now()) as one function that can be inserted into a database?
>
> I assume you've got your field as a DateTime format - if not, then change it
> to be DateTime
>
> Also, try to use the database native functions - Now() for Access and
> GetDate() for SQL Server - it'll be faster and cleaner than getting CF to do
> the work
>
> If you really want to use CF to do it, then use
> #CreateODBCDateTime(Now())# - assuming you're talking to the database ODBC
> and not OLE DB
>
> Try not to use DateFormat and TimeFormat into a format that "looks" right
> for you - the database server may look at is as just some text and produce
> an error - if you're fixed on the idea of using a set DateFormat, then use
> one that isn't ambigious, like "d mmm ", that way, it can't be
> confused - DEFINITELY avoid formats like "mm/dd/" as some databases may
> interpret it as "dd/mm/yy" (depending on nationalisation)
>
> HTH
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
RE: Textareas
Are you using Netscape to view the fields? Try IE--Netscape will cut off text in text boxes at much less than the 64K limit inherent in Cold Fusion. I don't know of any work around for that. Jeff Epstein Web Producer -Original Message- From: Jamie Symonds [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 12:53 PM To: [EMAIL PROTECTED] Subject: Textareas Hello again - Question regarding TEXTAREAs - I am using textareas to submit data to my memo field in an Access database - it seems as though there's a limit on how much info I can submit through them - any suggestions, ideas, or comments? I would like to be able to submit very large chunks of text and not have them cut-off half-way through. Thanks everyone. You all rock. Jamie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Tricky Password Question!
You can generate a random number with the Randomize function, although I don't know if you can limit it to three numbers. Jeff Epstein Web Producer -Original Message- From: morris johnston [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 11:45 AM To: [EMAIL PROTECTED] Subject: Tricky Password Question! Hi people, I'm trying to solve this problem of generating a random password can anyone asisst? It goes like this... a user enters a unique Login ID which is checked against a Dbase. (select loginID, id2,index >From table 1 Where loginID = form.loginID Next, If loginID doesn't exist; Then carry out instructions to generate new Id2 = / composed of: random 3 characters = the digits 001 at the end. Insert this new Id2 along with the form.LoginID into the table to create new record. ELSE if LoginID exists: (or a number of reocords exists which belong to user with form.loginid: use the value of the last Id2 inserted in the table or the record with an Id2 value with the highest digit value i.e. if 2 records were inserted into the table xxx001, and xxx002, the latter id2 value of xxx002 will be used to generate the new Id2 value: so that it should be an increment of 1 or new Id2 value = xxx003 . Hence the new reocord will have the field values of: LoginID = Form.loginid, id2 = xxx003 Any suggestion. I'll post any which I can come up with also. Thanks. M. --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
congratulations Daddy Camden
I don't know if you guys have been informed yet, but congratulations to Raymond Camden on the adoption of his perfect baby boy. He's finally here! http://www.camdenfamily.com/jacob/arrival/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: can this be done ? Part 2
Hi Gregg, > > > Paul or whoever can answer me, having a hard time understanding some of > this logic. The next botton and previous buttons do not work, and seem to > be switched. Any ideas what I am doing wrong ? Here is the code, thanks. > I had a look at the code you gave... It looked a little over complex, so I stripped a load of the code out and wound up with this: SELECT id, state, statename, company FROM HBMF Order by statename #statename# #company# One of the reasons your previous code may not have been working was because of the use of the start variable. By not specifying the scope of the variable and using to check the existance of the variable, you were probably winding up with a start variable in the 'variables' scope and one in the 'form' scope and looking at the 'variables' scope version rather than the one passed from the form. So what I've done is made sure that the start variable is properly referenced, by using form.start in the cfparam and for any other references. Hope this is a little clearer. Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Textareas
Jamie, > > Hello again - Question regarding TEXTAREAs - I am using textareas to > submit data to my memo field in an Access database - it seems as though > there's a limit on how much info I can submit through them - any > suggestions, ideas, or comments? I would like to be able to submit very > large chunks of text and not have them cut-off half-way through. Thanks > everyone. > The maximum number of characters you can put in a memo field is 65500 characters(ish), so you won't be able to put any more than that in without up sizing to something like SQL Server. Does the text really need to be in the database? If its text documents, why not just provide a reference to a file that has been uploaded, then index the files using verity? > You all rock. > Thanks... ;o) Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Textareas
At 01:53 PM 7/31/00 -0400, you wrote: >Hello again - Question regarding TEXTAREAs - I am using textareas to >submit data to my memo field in an Access database - it seems as though >there's a limit on how much info I can submit through them - any >suggestions, ideas, or comments? I would like to be able to submit very >large chunks of text and not have them cut-off half-way through. Thanks >everyone. You all rock. Check to see if it is cutting off at 4k. There is a 4k SQL limit that may be your problem, but there are ways to get around it. Also make sure that you aren't using IE for Mac. It passes everything through url variables and ends up cutting off information. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Time add
DateAdd works with any Date/Time object. To use DateAdd with time, just use
the appropriate time specifier where you're used to using the date
specifier. For example, DateAdd("H", 1, Now()).
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTECTED]
Ph. 714-896-3462
Fx. 714-896-3303
> -Original Message-
> From: Eli Shechter [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 8:49 AM
> To: [EMAIL PROTECTED]
> Subject: Time add
>
> Is there a function to do the adding with time. (like DateAdd)
> i want to create a output with the hours of the day by the half hour.
>
> meaning:
>
> 8:00
> 8:30
> 9:00
> 9:30
>
> does anyone know of a way to do this??
>
> Thanx
> -Eli-
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
RE: CV/Resume Project Descriptions
Hello Jamie. While I am not involved in HR, I have hired (and yes, fired) many people over the years. On a resume, you really don't want to "describe" your work, just your knowledge and accomplishments (which, when you are in school, may be just beginning). Use the resume to entice the prospective employer to contact you. You only have a few minutes to catch their attention. Pretty soon there is no way in heck you could list all your work, except as an addendum available on request. Make it functional, like: It should be bulleted if you are young, paragraphs as you get more accomplished. Ex. (beginning version) * Designed, managed and completed several campus-wide, dynamic, web-based applications (list available on request). * Familiar with Transact-SQL and PL/SQL on Microsoft SQL Server and Oracle. (this could go in a 'Skills' section at the end too) * Worked with departments to implement campus-wide support systems on the web. These are dynamic. Etc, etc. (this is the more accomplished version) Responsible for development and oversight of a 25 person engineering and development time covering a range of disciplines including yada, yada. As you get older (or rather grow in knowledge and accomplishments, you may be a 75 year old undergrad for all I know ;)) your resume will change. Keep it short, no more than one page. Focus a little on your schooling for now. That has consumed most of your time to date. Tell how you worked your way through school by doing this development. Ex: * 40% of tuition earned doing dynamic web development. Try not to use the word "I". Almost think in the 3rd person. Instead of: I have done this or that. Go with Have done this or that. Just some thoughts. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 http://dacnet.rice.edu/DAC-Net/Staff/Gary/ "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein > -Original Message- > From: Jamie Symonds [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 12:42 PM > To: [EMAIL PROTECTED] > Subject: CV/Resume Project Descriptions > > > Hello - I'm updating my resume since I've become familiar with > ColdFusion. I have worked independently on two projects for my > university - one for storing, retrieving and updating survey data from > faculty members, and a second project for the Students' Union, a message > board of sorts where students can post textbooks for sale or trade and > have them sorted by programme, course, etc. Sorry for rambling here, > but I'm curious as to how I describe these two projects on my Resume for > prospective employers? I'm sure some of you out there are involved in > HR with your organization and can tell me what you specifically look > for. MANY THANKS!! It's really appreciated. > > -Jamie > Bachelor of Information Systems student, St. Francis Xavier University > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE:
Lucas Lucas would would like like to to unsubscribe unsubscribe but but he he didn't didn't read read the the footer footer on on how how to to unsubscribe unsubscribe. Too Too bad bad. - Steve*2 -Original Message- From: Lucas Lucas [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 12:26 PM To: [EMAIL PROTECTED] Subject: unsubscribe ___ Say Bye to Slow Internet! http://www.home.com/xinbox/signup.html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Date subtraction
I replied to this thread when there were no other replies, but my reply didn't show up until three or four others did. It's the delay on sending out messages from the list. -Kev > -Original Message- > From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 11:39 AM > To: '[EMAIL PROTECTED]' > Subject: RE: Date subtraction > > > Could everybody please read to the end of a thread before replying? Rather > than repeating the same answer over and over again. > > (No flame intended) > > > Adam Reynolds > > > ** > This email and any attachments are confidential and solely > for the use of the intended recipient. They may contain > material protected by legal professional or other privilege. > If you are not the intended recipient or the person responsible > for delivering to the intended recipient, you are not authorised > to and must not disclose, copy, distribute or retain this email > or its attachments. Although this email and its attachments > are believed to be free of any virus or other defect, it is the > responsibility of the recipient to ensure that they are virus free > and no responsibility is accepted by the company for any > loss or damage arising from receipt or use thereof. > > ** > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE: Time add
Eli, Try something like this: #Now()# #CreateODBCDateTime(Evaluate(Now()+CreateTimeSpan(0,0,30,0)))# The first line outputs the current d/t and the second line demonstrates that half an hour has been added to it by way of the CreateTimeSpan function. Steve > -Original Message- > From: Eli Shechter [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 16:49 > To: [EMAIL PROTECTED] > Subject: Time add > > > Is there a function to do the adding with time. (like DateAdd) > i want to create a output with the hours of the day by the half hour. > > meaning: > > 8:00 > 8:30 > 9:00 > 9:30 > > does anyone know of a way to do this?? > > Thanx > -Eli- > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
OT: Javascript / DHTML List
Hi, This is off topic... Can anyone recommend a good Javascript / DHTML list for advanced developers? Thanks, Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Time add
Just use Date add but using the arguments h,n or s. :)
dateadd("h",1,datevar) adds 1 hour
dateadd("n",30,datevar) adds 30 minutes
Chung
-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 7:49 AM
To: [EMAIL PROTECTED]
Subject: Time add
Is there a function to do the adding with time. (like DateAdd)
i want to create a output with the hours of the day by the
half hour.
meaning:
8:00
8:30
9:00
9:30
does anyone know of a way to do this??
Thanx
-Eli-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
Re: CV/Resume Project Descriptions
I'm interested in how such projects are presented on a resume as well. If you get any private replies, I'd appreciate if you also pass on any relevant information :-) Ciao! -Gel - Original Message - From: Jamie Symonds <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> >Sorry for rambling here, > but I'm curious as to how I describe these two projects on my Resume for > prospective employers? I'm sure some of you out there are involved in > HR with your organization and can tell me what you specifically look > for. MANY THANKS!! It's really appreciated. > > -Jamie > Bachelor of Information Systems student, St. Francis Xavier University -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Time add
Hi Eli, > > > Is there a function to do the adding with time. (like DateAdd) > i want to create a output with the hours of the day by the half hour. > > meaning: > > 8:00 > 8:30 > 9:00 > 9:30 > > does anyone know of a way to do this?? > DateAdd will do this... DateAdd(datepart, number, date) datepart has the following options : -- Year q -- Quarter m -- Month y -- Day of year d -- Day w -- Weekday ww -- Week h -- Hour n -- Minute s -- Second Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Textareas
Hello again - Question regarding TEXTAREAs - I am using textareas to submit data to my memo field in an Access database - it seems as though there's a limit on how much info I can submit through them - any suggestions, ideas, or comments? I would like to be able to submit very large chunks of text and not have them cut-off half-way through. Thanks everyone. You all rock. Jamie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: WML and CF
Charlie Arehart has a brand new book, "Professional WAP" (isbn 1861004044) -Original Message- From: Erki Esken [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 8:46 AM To: [EMAIL PROTECTED] Subject: Re: WML and CF Maybe this new article from Allaire helps you somewhat: http://www.allaire.com/handlers/index.cfm?id=16516&Method=Full Also Allaire's WAP Reference Deck: http://www.allaire.com/developer/TechnologyReference/wap.cfm And Ben Forta's "No strings attached" article on CFDJ: http://www.sys-con.com/coldfusion/archives/0106/forta/ Erki - Original Message - From: "Amar Desai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 24, 2000 9:44 PM Subject: WML and CF > Question > does anyone have information on material available that can help in making > an existing cfm site to WAP compatible. > > Ben Forta's text, I believe does not have information on the subject. > thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
Tricky Password Question!
Hi people, I'm trying to solve this problem of generating a random password can anyone asisst? It goes like this... a user enters a unique Login ID which is checked against a Dbase. (select loginID, id2,index >From table 1 Where loginID = form.loginID Next, If loginID doesn't exist; Then carry out instructions to generate new Id2 = / composed of: random 3 characters = the digits 001 at the end. Insert this new Id2 along with the form.LoginID into the table to create new record. ELSE if LoginID exists: (or a number of reocords exists which belong to user with form.loginid: use the value of the last Id2 inserted in the table or the record with an Id2 value with the highest digit value i.e. if 2 records were inserted into the table xxx001, and xxx002, the latter id2 value of xxx002 will be used to generate the new Id2 value: so that it should be an increment of 1 or new Id2 value = xxx003 . Hence the new reocord will have the field values of: LoginID = Form.loginid, id2 = xxx003 Any suggestion. I'll post any which I can come up with also. Thanks. M. --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Date subtraction
This is a multi-part message in MIME format. --=_NextPart_000_03FC_01BFFB0E.B3432820 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Date subtraction>Could everybody please read to the end of a thread = before replying? This is a result of latency in the delivery of mail from the list. Some = of us haven't seen the first answer when we see the initial question. = That is why there are so many "duplicate" answers. DC --=_NextPart_000_03FC_01BFFB0E.B3432820 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Date subtraction >Could everybody = please read to the=20 end of a thread before replying? This is a result of latency in the = delivery of mail=20 from the list. Some of us haven't seen the first answer when we = see the=20 initial question. That is why there are so many "duplicate"=20 answers. DC --=_NextPart_000_03FC_01BFFB0E.B3432820-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
CV/Resume Project Descriptions
Hello - I'm updating my resume since I've become familiar with ColdFusion. I have worked independently on two projects for my university - one for storing, retrieving and updating survey data from faculty members, and a second project for the Students' Union, a message board of sorts where students can post textbooks for sale or trade and have them sorted by programme, course, etc. Sorry for rambling here, but I'm curious as to how I describe these two projects on my Resume for prospective employers? I'm sure some of you out there are involved in HR with your organization and can tell me what you specifically look for. MANY THANKS!! It's really appreciated. -Jamie Bachelor of Information Systems student, St. Francis Xavier University -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date subtraction
Sure ... if we had all of the thread. There would be NO thread if we all waited to see who sent back a reply first. Look at the times, about a 10-15 minute time span. (no flame intended) -Gary McNeel > -Original Message- > From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 10:39 AM > To: '[EMAIL PROTECTED]' > Subject: RE: Date subtraction > > > Could everybody please read to the end of a thread before replying? Rather > than repeating the same answer over and over again. > > (No flame intended) > > > Adam Reynolds > > > ** > This email and any attachments are confidential and solely > for the use of the intended recipient. They may contain > material protected by legal professional or other privilege. > If you are not the intended recipient or the person responsible > for delivering to the intended recipient, you are not authorised > to and must not disclose, copy, distribute or retain this email > or its attachments. Although this email and its attachments > are believed to be free of any virus or other defect, it is the > responsibility of the recipient to ensure that they are virus free > and no responsibility is accepted by the company for any > loss or damage arising from receipt or use thereof. > > ** > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
No Subject
unsubscribe ___ Say Bye to Slow Internet! http://www.home.com/xinbox/signup.html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Determining Datasources
I'm in the process of writing an Oracle User Administration (add delete users, role management etc) sub-fusebox and need to know if it is possible to automatically determine the names of the available Oracle 8 datasources that the current server has. Has anybody done this or knows how to do this? Thanks Adam Reynolds ColdFusion Consultant H.J. Heinz Tel.: +44 (0) 20 8756 5170 Mob.: +44 (0) 7973 386620 ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Time add
Is there a function to do the adding with time. (like DateAdd) i want to create a output with the hours of the day by the half hour. meaning: 8:00 8:30 9:00 9:30 does anyone know of a way to do this?? Thanx -Eli- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: ot: sql delete
At 08:06 AM 7/31/00 -0500, you wrote: >heh, > >any way to undelete something you deleted in a sql server database that was >not being backed up? Depending on the software and settings, you might be able to use a rollback function. Some databases can be commanded to rollback to a certain date, from what I understand. Check your documentation for rollback functions. The problem is that if you rollback you lose all changes since the time you rollback to. You may have to do some backups of current data to keep more recent changes. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Function for padding strings???
> > Here's one option: > > > > > > > > > > > Or you could be a smart ass and do it in one line : > > > > > ;o) That's still 2 lines Stephen ;-) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date subtraction
Could everybody please read to the end of a thread before replying? Rather than repeating the same answer over and over again. (No flame intended) Adam Reynolds ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: JavaScript background image question
> I pesume you are performing a function in frame 'A' which needs to set the > background poperty in frame 'B'??? This is how you do it (IE)... > > In frame 'A' do a parent.chgBack() > > In your frameset template setup function chgBack() to simply call function > B.chgImg() > > In frame 'B' function chgImg() simple perform document.body.background = > 'image.jpg' > > This works for me on IE5. NN does not support document.body.background. This works like a dream on IE5, I'll have to look for a solution for NN - I don't know whether it doesn't want the "body" part. Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Access to SQL
Hello fellow CF'ers We have upsized several of our Access databases to SQL 7 and they work great. While we are building the forms to update the database directly does anybody see any problems with running our updates from the Access to the SQL via standard SQL statements. For the time that's what we have been doing, but I was looking for some insight if there are any problems with this method. Right now we just upload the Access database to our Shared hosting space, then execute a template against it which pulls the data out and inserts, updates, or deletes it from our SQL space. Are there any hidden traps I should be worried about by doing this way not using the SQL scripts. Thanks. Bill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
re:can this be done ? Part 2
Paul or whoever can answer me, having a hard time understanding some of this logic. The next botton and previous buttons do not work, and seem to be switched. Any ideas what I am doing wrong ? Here is the code, thanks. SELECT id, state, statename, company FROM HBMF Order by state SELECT id, state, statename, company FROM HBMF Order by company #statename# #company# -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: Function for padding strings???
Look at RJustify CJustify LJustify. RepeatString ~Justin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 3:18 PM Subject: Function for padding strings??? > > > Hello all, >This might sound like a very stupid question, I need > to pad a string with spaces, so that i can pass the value to > a DB2 AS/400 Stored procedure. > The SP has to get in format with no "," or any chars. > Its kinda like a List with no special chars but the width of > the list should be 300 and each part should be 15 chars long.. > picky DB2/RPG SP. > > Ljustify is not working!!! > Is there a fuction to pad strings?? > > Appretiate any comments > > thanks > Joe > > > - > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web browser, anywhere! > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
(OT) Instructional Media
We are interested in purchasing some training courses on video or CD-ROM for areas such as XML. I have looked at AppDev and they seem promising. Does anyone have any feedback on AppDev video or CD-ROM courses, or does anyone have any recommendations for other CBT providers? Thanks, Rob ___ Robert M. Saxon, Jr. (Rob), Senior Web Developer Mercer University Department of Web Management TSS // 1400 Coleman Avenue // Macon, GA 31207 912-301-5550 voice // 912-301-5314 fax [EMAIL PROTECTED] Philippians 4:13 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date subtraction
> > Is there a way to substract days from a date value similar to the = > dateAdd function in CF. I looked through the manual and I am not seeing = > anything. What I am trying to do is set up date values 2 weeks before = > and 2weeks after todays date. > What you need to use is the DateAdd() function. Its easy enough to use and allows you to add day, months and years using the datepart function. You can give the datepart function negative numbers, so that it will subtract a period of time from your start date. HTH Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date subtraction
You can use negative values with the dateAdd() function to get dates from
the past. Just specify dateAdd("d", -14, baseDate).
-Kev
> -Original Message-
> From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 12:13 PM
> To: [EMAIL PROTECTED]
> Subject: Date subtraction
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_1637_01BFFAE0.554B4DC0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Is there a way to substract days from a date value similar to the =
> dateAdd function in CF. I looked through the manual and I am not seeing =
> anything. What I am trying to do is set up date values 2 weeks before =
> and 2weeks after todays date.
>
> Thanks!
>
> Kevin Schmidt
> Internet Services Manager
> Peterson, WIlliams & Bizer
> Office: 734.995.5000
> Mobile: 734.649.4843
>
>
> --=_NextPart_000_1637_01BFFAE0.554B4DC0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>
>
> http-equiv=3DContent-Type>
>
>
>
>
> Is there a way to substract days from a =
> date value=20
> similar to the dateAdd function in CF. I looked through the manual =
> and I=20
> am not seeing anything. What I am trying to do is set up date =
> values 2=20
> weeks before and 2weeks after todays date.
>
> Thanks!
> Kevin SchmidtInternet Services=20
> ManagerPeterson, WIlliams & BizerOffice: =
> 734.995.5000Mobile:=20
> 734.649.4843
>
> --=_NextPart_000_1637_01BFFAE0.554B4DC0--
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
Re: Date subtraction
Use the DateAdd function as usual, just use a negative number (-1, -2) in the "add" place, that should do it :-) Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 07/31 9:13 AM >>> This is a multi-part message in MIME format. --=_NextPart_000_1637_01BFFAE0.554B4DC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a way to substract days from a date value similar to the = dateAdd function in CF. I looked through the manual and I am not seeing = anything. What I am trying to do is set up date values 2 weeks before = and 2weeks after todays date. Thanks! Kevin Schmidt Internet Services Manager Peterson, WIlliams & Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1637_01BFFAE0.554B4DC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a way to substract days from a = date value=20 similar to the dateAdd function in CF. I looked through the manual = and I=20 am not seeing anything. What I am trying to do is set up date = values 2=20 weeks before and 2weeks after todays date. Thanks! Kevin SchmidtInternet Services=20 ManagerPeterson, WIlliams & BizerOffice: = 734.995.5000Mobile:=20 734.649.4843 --=_NextPart_000_1637_01BFFAE0.554B4DC0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date subtraction
How about adding a negative number of days? ;) Paul > -Original Message- > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] > Sent: 31 July 2000 17:13 > To: [EMAIL PROTECTED] > Subject: Date subtraction > > > This is a multi-part message in MIME format. > > --=_NextPart_000_1637_01BFFAE0.554B4DC0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Is there a way to substract days from a date value similar to the = > dateAdd function in CF. I looked through the manual and I am > not seeing = > anything. What I am trying to do is set up date values 2 > weeks before = > and 2weeks after todays date. > > Thanks! > > Kevin Schmidt > Internet Services Manager > Peterson, WIlliams & Bizer > Office: 734.995.5000 > Mobile: 734.649.4843 > > > --=_NextPart_000_1637_01BFFAE0.554B4DC0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > Is there a way to substract > days from a = > date value=20 > similar to the dateAdd function in CF. I looked through > the manual = > and I=20 > am not seeing anything. What I am trying to do is set up date = > values 2=20 > weeks before and 2weeks after todays date. > > Thanks! > Kevin SchmidtInternet Services=20 > ManagerPeterson, WIlliams & BizerOffice: = > 734.995.5000Mobile:=20 > 734.649.4843 > > --=_NextPart_000_1637_01BFFAE0.554B4DC0-- > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
