RE: DATES!!!!!!!!!`
try using single quote's: WHERE creationdate >= '#dateA#' and creationdate <= '#dateB#' Regards, Johan -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: woensdag 26 juli 2000 14:20 To: [EMAIL PROTECTED] Subject: Re: DATES!` On 7/26/00, Jason Glaun penned: >I have a problem with getting records out of an access database that have >creation dates between dateA and dateB. I just cant get the query to work! >Anyone got any suggestions WHERE creationdate >= #dateA# and creationdate <= #dateB# Always works for me. As a side note. I have had problems in the past if I name a field with an underscore in front of date. Like creation_date. I always name them creationdate without the underscore. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- 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: Surprising Results? [was] Re: Round down numbers
Hello Dick, As a mathemetics student all of these answers seem correct to me ... Round(-4.5) indeed is -5 Int(-4.5) indeed is -5 Johan Coens -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: woensdag 26 juli 2000 15:55 To: [EMAIL PROTECTED] Subject: Surprising Results? [was] Re: Round down numbers Hmmm. All this talk about rounding up/down... thought I'd experiment: ...Ceiling(4.5)Gives 5.Expect 5..|#Ceiling(4.5)#| ...Ceiling(4.4)Gives 5.Expect 5..|#Ceiling(4.4)#| ...Ceiling(-4.5)...Gives -4Expect -4.|#Ceiling(-4.5)#| ...Ceiling(-4.4)...Gives -4Expect -4.|#Ceiling(-4.4)#| ...Round(4.5)..Gives 5.Expect 5..|#Round(4.5)#| ...Round(4.4)..Gives 4.Expect 4..|#Round(4.4)#| .*.Round(-4.5).Gives -5Expect -4.|#Round(-4.5)#| .*.Round(-4.4).Gives -4Expect -5.|#Round(-4.4)#| ...Int(4.5)Gives 4.Expect 4..|#int(4.5)#| ...Int(4.4)Gives 4.Expect 4..|#int(4.4)#| .*.Int(-4.5)...Gives -5Expect -4.|#int(-4.5)#| .*.Int(-4.4)...Gives -5Expect -4.|#int(-4.4)#| ...Fix(4.5)Gives 4.Expect 4..|#Fix(4.5)#| ...Fix(4.4)Gives 4.Expect 4..|#Fix(4.4)#| ...Fix(-4.5)...Gives -4Expect -4.|#Fix(-4.5)#| ...Fix(-4.4)...Gives -4Expect -4.|#Fix(-4.4)#| Gives the somewhat unexpected: ...Ceiling(4.5)Gives 5.Expect 5..|5| ...Ceiling(4.4)Gives 5.Expect 5..|5| ...Ceiling(-4.5)...Gives -4Expect -4.|-4| ...Ceiling(-4.4)...Gives -4Expect -4.|-4| ...Round(4.5)..Gives 5.Expect 5..|5| ...Round(4.4)..Gives 4.Expect 4..|4| .*.Round(-4.5).Gives -5Expect -4.|-5| .*.Round(-4.4).Gives -4Expect -5.|-4| ...Int(4.5)Gives 4.Expect 4..|4| ...Int(4.4)Gives 4.Expect 4..|4| .*.Int(-4.5)...Gives -5Expect -4.|-5| .*.Int(-4.4)...Gives -5Expect -4.|-5| ...Fix(4.5)Gives 4.Expect 4..|4| ...Fix(4.4)Gives 4.Expect 4..|4| ...Fix(-4.5)...Gives -4Expect -4.|-4| ...Fix(-4.4)...Gives -4Expect -4.|-4| At 8:30 AM -0400 7/26/00, Bud wrote: >On 7/26/00, wai-leng penned: >>Hi all, >> >>I am using Round () to round numbers but I would like it to round down >>ie 469.50 should be evaluated as 469 instead of 470. >> >>Any suggestions please > >Well, since round always rounds up or down accordingly, except .5 >which always rounds up, I presume you always want to round down, in >which case int(number) will do it. >-- > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development >[EMAIL PROTECTED] >http://www.twcreations.com/ >954.721.3452 >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal >k 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: substituting variables in a variable
Try putting all between cfoutput tags. Johan Coens -Original Message- From: Neil Peaslee [mailto:[EMAIL PROTECTED]] Sent: woensdag 26 juli 2000 16:17 To: cf-talk Subject: substituting variables in a variable I am trying to set up a mail system that can grab text from a database and insert it into a mail message. I also need to customize the text of the message (e.g. Dear #first_name# evaluates to Dear John). The problem arises when I insert the mail text variable into the tag. The variables that are contained in the text message are not evaluated. #mail_message# This will output "Dear #first_name#, ..." How do I get the sub variable to be evaluated? Thanks in advance, Neil -- 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: Dates!!!!! (code)
Hello, I also used date comparison in Access, and expirienced the same. You have to use date comparison in queries like this: SELECT * FROM Reference WHERE Archive_Date > #CreateODBCDateTime(date1)# AND Archive_Date < #CreateODBCDateTime(date2)# That should work. Regards, Johan --> Ben said this before: You should use: WHERE creationdate >= #CreateODBCDate(dateA)# AND creationdate <= #CreateODBCDate(dateB)#. You should never use dates directly (in a WHERE clause or any other part of a SQL statement) without using one of CreateODBCDate() CreateODBCTime() or CreateODBCDateTime(). That's the only safe way to use dates consistently. Also, you can use the BETWEEN clause. --- Ben -Original Message- From: Jason Glaun [mailto:[EMAIL PROTECTED]] Sent: donderdag 27 juli 2000 10:21 To: [EMAIL PROTECTED] Subject: Dates! (code) This is a multi-part message in MIME format. --=_NextPart_000_0026_01BFF7AB.F1534DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you have a chance could you just have a glance at this for me? = thanks. I am having trouble with something that I can't seem to get righ and was wondering if you had any advice for me. It's a SQL problem. I'm = trying to get the dates from the database which lie between date_A and date_B = but it won't give me any!!! here is my query.. Version 1 SELECT * FROMReference WHERE Archive_Date BETWEEN #variables.date_A# AND #variables.date_B# Version 2 SELECT * FROMReference WHERE Archive_Date > #variables.date_A# AND Archive_Date < #variables.date_B# it just won't seem to work! I get 2 errors depending on '' around the variables. error 1(without #variable# ) [Microsoft][ODBC Microsoft Access 97 Driver]Division by zero (null) error2 (with'#variable#' ) Data type mismatch in criteria expression can't I do a greater or lessthan calculation on a date? Thanks. --=_NextPart_000_0026_01BFF7AB.F1534DE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you have a chance = could you just=20 have a glance at this for me? thanks.I am having trouble = with=20 something that I can't seem to get righ and waswondering if you had = any=20 advice for me. It's a SQL problem. I'm = tryingto get=20 the dates from the database which lie between date_A and date_B = butit won't=20 give me any!!!here is my query..Version 1SELECT&nb= sp;=20 *FROM ReferenceWHERE=20 Archive_Date BETWEEN #variables.date_A# AND=20 #variables.date_B# Version = 2SELECT&nb= sp;=20 *FROM ReferenceWHERE=20 Archive_Date > #variables.date_A# AND Archive_Date=20 <#variables.date_B# it just won't seem = to=20 work! I get 2 errors depending on '' around = thevariables.error=20 1(without #variable# )[Microsoft][ODBC Microsoft Access 97=20 Driver]Division by zero (null)error2 (with = '#variable#' )Data type mismatch in criteria=20 expressioncan't I do a greater or lessthan calculation on a=20 date? Thanks. --=_NextPart_000_0026_01BFF7AB.F1534DE0-- -- 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: How to release cached data source connection via CF template ?
Helle Adam, I hope this is what you ment: Use a false query like SELECT NOTHING FROM SOMETHING This generates a dbError which you can catch using Then your datasource will be released. Regards, Johan -Original Message- From: Jablonski, Adam, MTC-CEC [mailto:[EMAIL PROTECTED]] Sent: donderdag 27 juli 2000 12:10 To: [EMAIL PROTECTED] Subject: How to release cached data source connection via CF template ? Hello, the subject is THE question. I need to copy database files in automated way. In connection to this all those files have to be released by CF server. Does anyone of you know such a custom tag or any other solution to solve this problem? I need exactly the same functionality as the CF server administrator on DataSources/VerifyDataSource page but regarding only one given cached data source connection to release. Thanks in advance, Adam -- 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: Need help from a pro
Try CreateODBCDate(Now()) Like: ... WHERE StartDate <= CreateODBCDate(Now()) AND EndDate >= CreateODBCDate(Now()) R. Johan -Original Message- From: Mike Weaver [mailto:[EMAIL PROTECTED]] Sent: zondag 30 juli 2000 8:08 To: [EMAIL PROTECTED] Subject: Need help from a pro This is a multi-part message in MIME format. --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am in need of guidance on dates. I am using an Access db. and = have a query which generates records between 2 dates you enter in a = form. The date input for each record is the automatic access db = function. I can't seem to get the #DateFormat(Now())# to work in single or double = quotes so I used the auto function. When I run the query I get an error = of division by zero. Any assistance is greatly appreciated. Mike --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am in need of guidance = on=20 dates. I am using an Access db. and have a query = which=20 generates records between 2 dates you enter in a form. The date = input for=20 each record is the automatic access db function. I can't seem to get the = #DateFormat(Now())# to=20 work in single or double quotes so I used the auto function. When = I run=20 the query I get an error of division by zero. Any assistance is greatly=20 appreciated. Mike --=_NextPart_000_0028_01BFF9B1.CB80B280-- -- 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: Desperately need help - sorting a QueryNew()
Hello, When you sort on mathematical expressions like SUM() you need to use GROUP BY. ORDER BY cannot contain mathematical expressions. R. Johan Coens -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 11:27 To: '[EMAIL PROTECTED]' Subject: RE: Desperately need help - sorting a QueryNew() > See > http://www.mail-archive.com/cf-talk@houseoffusion.com/msg14920 > .html for > sorting queries Thanks - I'll take a look at the tag. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- 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: Help with CFLocation and Frames
Hello, You have to use Javascript when changing the location of other frames. R. Johan Coens -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 11:58 To: [EMAIL PROTECTED] Subject: Help with CFLocation and Frames I am using the cf location tag however I need to be able to control which frame the tag refreshes in most cases I need to refresh the entire window that being the entire frame set as at the moment it will only refresh the frame that displays the page containing cflocation tag or else under these circumstances should I be using something other than cflocation and if so your advice would be greatly appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com 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.
RE: Desperately need help - sorting a QueryNew()
I think i need to do something about my db-knowledge ... Thanks, Johan -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 12:52 To: '[EMAIL PROTECTED]' Subject: RE: Desperately need help - sorting a QueryNew() > When you sort on mathematical expressions like SUM() you need to use GROUP > BY. ORDER BY cannot contain mathematical expressions. That's a bit misleading. 1. In most RDBMS, including Access which is what we're talking about, if you can SELECT BY it, you can ORDER BY it. 2. SUM() is an aggregate function, rather than just a mathematical expression. 3. GROUP BY and ORDER BY serve completely different purposes. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- 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: A knotty evaluate problem....
I had the same problem. What i did was a replace of all minus signs by an underscore. R. Johan Coens -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 13:14 To: Cf-Talk@Houseoffusion. Com Subject: A knotty evaluate problem Morning all I have a little problem. I have a form that has a number of items for which you can change the quantity for each item. The Quantity field is called Quantity_ and then has the item ID appended to this. In the update page I know the item ids for all the items on the previous page, so I loop through them and build up the variable and check to see whether the content has changed. No problem there The problem come when the seconf cfset above is executed. ID is a UUID generated by CreateUUID(). When CF tried to evalute it I get an error. The minus signs in the ID make CF try to subtract bits of the form field name from other bits eg. Form variable : OrderQuantity_B7935872-11DD-4FCB-887089EEAE37432C CF tries to subtract 11DD from OrderQuantity_B7935872 and gets its knickers in a twist when it sees the DD on the end of the number. Does any one have any ideas how I can stop it from doing this and get the contents of the variable? -- 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: A knotty evaluate problem....
That's indeed what you do. You collect the value like Evaluate("FORM.OrderQuantity_#Replace(url.id, "-", "_", "ALL")#") Good luck, Johan -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 13:34 To: [EMAIL PROTECTED] Subject: RE: A knotty evaluate problem > > I had the same problem. What i did was a replace of all minus signs by an > underscore. > [snip] > > Form variable : OrderQuantity_B7935872-11DD-4FCB-887089EEAE37432C > CF tries to subtract 11DD from OrderQuantity_B7935872 and gets > its knickers > in a twist when it sees the DD on the end of the number. > > Does any one have any ideas how I can stop it from doing this and get the > contents of the variable? > A So for everyone else's benefit and mine for clarification. You replace the minus signs on the form and do the same when you build up the variables on the "update" page. Cheers Johan. 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. -- 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
Hello, I allways use varchar. Not because of better performance but because of the following: If I insert into the database the value 'xyz' in a char(5) field, the value of it in the dBase will be 'xyz '. It automaticly puts spaces behind to fill up the empty space. This means you always have to trim you're values before u use them ... Maybe there's a setting in the dbServer, but i'm not such a dbWizard. Best Regards, Johan Coens -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 20:52 To: cf-talk Subject: 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. -- 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: Help!
Maybe: Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords Step 2: DELETE FROM , now you're table is empty Step 3: LOOP over qryAllRecords and insert them into the database. Make sure you have a backup and use CFTRANSACTION! Best Regards, Johan Coens -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: woensdag 2 augustus 2000 6:30 To: [EMAIL PROTECTED] Subject: Help! Hello All, There is a very seriuous problem I am facing. Please help. The problem is as follows: Somehow I have created duplicate records in SQL Server 7.0 table. I have to remove the duplicate the records. It all happened because there is no primary key when the record was created. If it were a few records, I could have manually deleted them. Now the records are in thousands. Can someone suggest me a code that would check for duplicate values in a table and delete them. Please help. A.B. __ 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. -- 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: CFIF and CFMAIL
Hello Jim, I think you have to specify a valid email address in the FROM attribute, otherwise it will not be sent. Also check your mail-logs, most of the time you can see inthere what went wrong. Also: is the same as , or if blairsville is a variable and Best Regards, Johan Coens -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: woensdag 2 augustus 2000 13:55 To: [EMAIL PROTECTED] Subject: CFIF and CFMAIL The following will not work. Exactly what do I need to do to change the mail header based on a variable? I sure would appreciate help on this :) etc, etc, Jim Watkins http://www.clarkes.tec.ga.us/blairsville -- 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: Allaire security problem - anyone know solution?
One easy solution to do: CFENCRYPT it -Original Message- From: Mooner Ent [mailto:[EMAIL PROTECTED]] Sent: vrijdag 4 augustus 2000 5:50 To: [EMAIL PROTECTED] Subject: Re: Allaire security problem - anyone know solution? Allaire security bulletin says Originally Posted: May 22, 2000 Last Updated: May 22, 2000 Why are we just finding out that our entire Server side code can be read??? I check the security section often, did I over look it? We found out about DATA much sooner. Rick Excuse the rant. - Original Message - From: "Daniel J. Cody" <[EMAIL PROTECTED]> Newsgroups: cf-talk To: <[EMAIL PROTECTED]> Sent: Thursday, August 03, 2000 9:46 AM Subject: Re: Allaire security problem - anyone know solution? > Dave, I wasn't able to reproduce this on CF 4.5.1 on Linux+Apache. I > think this might be more of an IIS issue than a CF one. Check out > http://www.securityfocus.com/focus/microsoft/iis/iismain.html for more > info on .htr issues. > > .djc. > > Dave Wilson wrote: > > > > Hi all, > > > > One of my hosting clients has just made me aware of this major security > > problem and I'm wondering if anyone knows how to eliminate it? > > > > Try calling the application.cfm template on any CF site with +.htr appended > > to the end of the url. You'll first see a blank page. Now hit refresh/reload > > and you'll see the full code of said application.cfm > > > > e.g. http://www.support.alllaire.com/application.cfm+.htr > > > > Can someone please tell me there is a patch for this. It seems to happen on > > all CFserver versions 4.x + running IS4.0 with Service pack 5 > -- > 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. __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.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. -- 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: Allaire security problem - anyone know solution?
What about CFENCODE .. I know it's not a solultion, but it is a way to 'protect' your code. This .htr invulnerability is one, but sure there will come other. -Johan -Original Message- From: Rick Osborne [mailto:[EMAIL PROTECTED]] Sent: vrijdag 4 augustus 2000 10:03 To: [EMAIL PROTECTED] Subject: RE: Allaire security problem - anyone know solution? You're kidding, right? http://devex.allaire.com/developer/gallery/info.cfm?ID=B61C031D-2CE5-11D4-83 D700508B94F85A&method=Full http://www.rixsoft.com/ColdFusion/CFX/CFMEncrypt/ http://packetstorm.securify.com/9907-exploits/cfdecrypt.txt http://shroom.dv8.org/bmp/crypt.cgi http://www.rewted.org/exploits/sorted-by-date/07-1999/cfdecrypt.c CF Encryption is broken. It'll keep honest people out of your code, but it is by no means a "solution". (Sorry, I'm not trying to be mean or anything, I just don't think it's good that people put all their eggs in one basket. Or, in this case, all of their faith in a broken system.) -Rick -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 3:46 AM To: [EMAIL PROTECTED] Subject: RE: Allaire security problem - anyone know solution? One easy solution to do: CFENCRYPT it -Original Message- From: Mooner Ent [mailto:[EMAIL PROTECTED]] Sent: vrijdag 4 augustus 2000 5:50 To: [EMAIL PROTECTED] Subject: Re: Allaire security problem - anyone know solution? Allaire security bulletin says Originally Posted: May 22, 2000 Last Updated: May 22, 2000 Why are we just finding out that our entire Server side code can be read??? I check the security section often, did I over look it? We found out about DATA much sooner. Rick Excuse the rant. -- 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: fuse box
Try http://www.fusebox.org/ -Original Message- From: Jaffar Zaidi [mailto:[EMAIL PROTECTED]] Sent: vrijdag 4 augustus 2000 12:56 To: [EMAIL PROTECTED] Subject: fuse box Hi every one Plz can any one tell me where can i get the documentation about Fuse box methodology Thankz Jaffar __ 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. -- 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 with IE and session management
Hello all, I've got a serious problem with IE and my applications. I've build a maintenance system running on my server at a subdirectory located in the wwwroot. The application which uses the content from the maintenancesystem is located in another subdirectory in the wwwroot. Both applications use sessionmanagement. The situation is: I run the website in browser window 1, the maintenance system in browser window 2. The problem is that as soon as I do something in the website (I click on a link) my session disappears in my maintenance system. This causes me to login. This situation also happens when I am in the CFAdmin. When performing an action in the CFAdmin (just click one of the links in the left) my session disappears in my maintenance system. This problem only occurs with Internet Explorer, Netscape is doing fine. I don't want to pass the CFID and CFTOKEN all around my app. in the URL. I know that solves the problem, but for that I have to rewrite all my code... I passed the test with full lock checkings in the CFAdmin, so all my locking is OK. My question(s): 1. Has anyone experienced this behaviour of IE (and overcame the problem) 2. Why does my CFID and CFTOKEN get overwritten/replaced in IE and not in Netscape 3. Why do my CFID and CFTOKEN only get overwritten in my maintenance system and not in the CFAdmin (that's what I think because I don't have to login again in the CFAdmin) 4. Does it have someting to do with including the application.cfm in subdirectories of my application. example /root/application.cfm (the root of my app) /root/subdir/application.cfm (includes the root application.cfm) etc. Any help would be appreciated! Kind regards, Johan Coens = Ing. Johan Coens Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Locking session variables in CF 4.0
Don't locking your application, session and server vars means crashing your cfserver, overwriting session and application information from other running applications. You are messing up your shared memory. This is why locking is that important. -Original Message- From: Barney Stevenson [mailto:[EMAIL PROTECTED]] Sent: dinsdag 19 december 2000 12:53 To: CF-Talk Subject: Locking session variables in CF 4.0 I am confused by the knotty subject of locking session variables. I know that it is recommended to lock all session variables in CF 4.5, but should I be locking if I am developing for CF 4.0. What will happen if I don't implement locks? Regards Barney = Barney Stevenson 77 Church Street Heaton Norris Stockport Cheshire SK4 1JH United Kingdom +44(0)161 429 6675 Pager: +44(0)7654 248701 Fax: +44(0)870 831 0837 "We work to become, not to acquire". Elbert Hubbard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Refreshing images without refreshing page
Hello Paul, Maybe you can use Javascript with the setTimeout function. This way you can refresh your images by setting the img.scr = 'abanner.gif' every ... milliseconds. The banners must have the same height and width ofcourse. Best regards, Johan Coens = Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: woensdag 20 december 2000 15:15 To: CF-Talk Subject: Refreshing images without refreshing page I'm putting together an application for a client that includes banner ads. They are interested in setting it up so that an ad rotates every 30 or 45 seconds on a page while a viewer is reading it. So that in the span of 5 minutes or so, a banner would rotate 8 or 9 times without any refresh of the entire page. Anyone come up with a good way to handle this type of thing? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Duplicate supported in CF4.0
Quick question is the Duplicate function supported in CF4.0? Best regards, Johan Coens = Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate supported in CF4.0
How do you duplicate a structure in CF4.0? -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:40 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 No it's not! Allan Pichler Machine Dreams Inc. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 AM To: CF-Talk Subject: Duplicate supported in CF4.0 Quick question is the Duplicate function supported in CF4.0? Best regards, Johan Coens = Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate supported in CF4.0
Using StrucyCopy you still reference the original structure. So, when using structCopy of an application or session variable you still have a pointer to the shared memory -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:55 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 StructCopy(structure) -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:54 AM To: CF-Talk Subject: RE: Duplicate supported in CF4.0 How do you duplicate a structure in CF4.0? -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:40 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 No it's not! Allan Pichler Machine Dreams Inc. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 AM To: CF-Talk Subject: Duplicate supported in CF4.0 Quick question is the Duplicate function supported in CF4.0? Best regards, Johan Coens = Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate supported in CF4.0
Thanks Nick, I was afraid I had to do it that way, I hoped 4.0 had some mechanism to do it, but unfortunattly I have to do it my own. Just came up with an idea (from Spectra). In Spectra there is a customtag called deepcopy. What it does: This way you can easy dulpicate structs in CF4.0! Regards, Johan -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 11:25 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 Johan I believe you have to do a structNew() then CFLOOP through the original structure copying each element. This is easy if you know up front what elements the structure contains. Otherwise you have to use isStruct() and isArray() on each element to see if it's a nested structure or array, & if so create a corresponding new one in the target structure. Nick -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 10:11 AM To: CF-Talk Subject: RE: Duplicate supported in CF4.0 Using StrucyCopy you still reference the original structure. So, when using structCopy of an application or session variable you still have a pointer to the shared memory -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:55 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 StructCopy(structure) -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:54 AM To: CF-Talk Subject: RE: Duplicate supported in CF4.0 How do you duplicate a structure in CF4.0? -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:40 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 No it's not! Allan Pichler Machine Dreams Inc. -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 AM To: CF-Talk Subject: Duplicate supported in CF4.0 Quick question is the Duplicate function supported in CF4.0? Best regards, Johan Coens ===== Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate supported in CF4.0
But why doesn't allaire use StructCopy ... ;) -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 11:43 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 Not entirely true. Structcopy does actually duplicate the structure in question. I think there's some confusion here over which creates a pointer to the original. Structcopy however only performs a shallow copy in that any embedded structures within the structure that you are trying to duplicate aren't copied wholesale but are referenced through pointers. Steve -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: 21 December 2000 10:11 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 Using StrucyCopy you still reference the original structure. So, when using structCopy of an application or session variable you still have a pointer to the shared memory -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:55 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 StructCopy(structure) -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:54 AM To: CF-Talk Subject: RE: Duplicate supported in CF4.0 How do you duplicate a structure in CF4.0? -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 10:40 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 No it's not! Allan Pichler Machine Dreams Inc. -Original Message----- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 AM To: CF-Talk Subject: Duplicate supported in CF4.0 Quick question is the Duplicate function supported in CF4.0? Best regards, Johan Coens ===== Ing. Johan Coens Certified ColdFusion Developer Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash. "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate supported in CF4.0
Isn't is than always the best to use WDDX serialize/deserialize when duplicating structures? I think this ensures it that you always have a unique copy, and are not referencing any shared memory. Maybe a slight performance decrease, but you're sure your application works the way you want. Regards, Johan -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: donderdag 21 december 2000 14:20 To: CF-Talk Subject: RE: Duplicate supported in CF4.0 Be aware that there is a similar issue in Duplicate. If you duplicate a structure that has an array that has an element that is a struct, you will get a pointer. To see this, run this code: The simple value is NOT a pointer, #A.Arr[1]# B.Arr[2].Foo is a pointer. Here is the proof: #A.Arr[2].Foo# === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Steve Martin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 21, 2000 5:43 AM > To: CF-Talk > Subject: RE: Duplicate supported in CF4.0 > > > Not entirely true. Structcopy does actually duplicate the structure in > question. I think there's some confusion here over somenewvar=anoldstruct> which creates a pointer to the original. > Structcopy > however only performs a shallow copy in that any embedded > structures within > the structure that you are trying to duplicate aren't copied wholesale but > are referenced through pointers. > > Steve > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: it wont loop back!....
try Back | &nbs p; Next 8 Best regards, Johan Coens -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: woensdag 27 december 2000 17:48 To: CF-Talk Subject: it wont loop back! here is my problem, when the code below gets ran it runs fine all accept when it gets to the end of the list of images it keeps going with blank pages with just a back and next button. my question is how do i get it to loop back to the beginning of the list when it gets to the end or last image? can anyone help? ive been stuck on this for some time now Select * >From ImageManager Early Work Click Image to order and to view larger picture. #RealName# Back | &nbs p;Next 8 Thanks much, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: This is weird
You forgot the quotes, so use SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName, > LastUpdate) VALUES('HPRO-12-28-2000', 'retreat', {ts '2000-12-28 18:42:56'})" instead of > SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName, > LastUpdate) VALUES(HPRO-12-28-2000, retreat, {ts '2000-12-28 18:42:56'})" Regrads, Johan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Datasources Using CF
Check the CF Developer Gallery for creating datasources. Regards, Johan Coens -Original Message- From: Tan Siew Ling [mailto:[EMAIL PROTECTED]] Sent: dinsdag 2 januari 2001 5:01 To: CF-Talk Subject: Creating Datasources Using CF Hi All Can i write CF codes to create datasources instead of using cold fusion admin? Thanks, Siew Ling ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: record sets... arrays or structures?
Try User[13].FullName, u can use that with recordsets. Structures work the same, and you have a tool called QueryToStruct, which converts your query to a structure. Regards, Johan Coens -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: donderdag 4 januari 2001 15:03 To: CF-Talk Subject: record sets... arrays or structures? subject says it all let's say a have a record set of users and wanted to get the first name of row #13. could i use something like: User.FirstName[13] ??? (except for the fact that this example doesnt seem to work) -- Mike Amburn, Development [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT
UUNET, there not cheap but their support is good, sites are fast. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 januari 2001 11:00 To: CF-Talk Subject: Slightly OT Hi All, Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion sites. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists