Re: OLE DB for SQL Server
Gena, In CFJ they had an article about a bug in setting this up. In the provider field put "SQLOLEDB" without the quotes. If it doesn't work, repeat the process from scratch, meaning delete your first try and then do it again. HTH, Rick - Original Message - From: "Gena" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 4:13 PM Subject: OLE DB for SQL Server Hi! Couldn't you explaine how to use OLE DB connection in CF 4.5. I cannot register DSN :( I suppose that some problem is with "Provider" and/or "ProviderDSN" parameters in Edit OLEDB Interface Data Source. Thank you Gennadi -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
accessing a query as an array
This is a multi-part message in MIME format. --=_NextPart_000_03C2_01C02F3E.4206BEB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to populate an array from a query and I am running into = problems... From what I have infered from the CF docs, CFQuery's are actually = arrays.=20 If we assume that then, #QueryName[1][4]# should return the data in the = first row and the fourth column..right?? My confusion comes from what seems to me to be conflicting info in Ben = Forta's book and the CF online docs.=20 Ben states on page 529 (4.0) that "Database queries returned by the = CFQUERY tag are actually 2D arrays..." The online docs say that "Query column data can be referenced using = array-like syntax. For example, myquery.col_name[1] references data in = the first row in the column col_name." If the latter is true then it seems to me that queries are not acutally = true 2D arrays but "arraylike" as it says... I have tried accessing the query as a true array but I get an error. = Code and error are below, if anyone can clear me up on what I am missing = I would be a very happy CF_programmer who can go home finally, becuase = the damn project is due today and this is the last thing and it's friday = and I have too much caffeine in me and i wont stop till I'm done! Error Diagnostic Information Error resolving parameter PRICEBREAKLOOP=20 ColdFusion was unable to determine the value of the parameter. This = problem is very likely due to the fact that either:=20 1.. You have misspelled the parameter name, or=20 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, = or CFTABLE tag. The error occurred while evaluating the expression:=20 pricebreaks[Major_Cat][looptracker] =3D PriceBreakLoop[1][looptraker] cfif application.queryStatus IS 1cfquery datasource=3D"#productdsn#" = name=3D"PriceBreaksQuery" dbtype=3D"ODBC"SELECT *FROM = Pricing/cfquerycfset pricebreaks =3D ArrayNew(2)cfloop = query=3D"PriceBreaksQuery"cfquery datasource=3D"#productdsn#" = name=3D"PriceBreaksLoop" dbtype=3D"ODBC"SELECT *FROM PricingWHERE = Major_Cat =3D '#Major_Cat#'/cfquery cfset looptracker =3D 0cfloop = query=3D"PriceBreaksLoop"cfset looptracker =3D (looptracker + = 1)cfset pricebreaks[Major_Cat][looptracker] =3D = PriceBreakLoop[1][looptraker]/cfloop /cfloop jon --=_NextPart_000_03C2_01C02F3E.4206BEB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am trying to populate an array from a = query and I=20 am running into problems.../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2From what I have infered from the CF = docs,=20 CFQuery's are actually arrays. /FONT/DIV DIVFONT face=3DArial size=3D2If we assume that then, = #QueryName[1][4]# should=20 return the data in the first row and the fourth = column..right??/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2My confusion comes from what seems to = me to be=20 conflicting info in Ben Forta's book and the CF online docs. = /FONT/DIV DIVFONT face=3DArial size=3D2Ben states on page 529 (4.0) that = "Database queries=20 returned by the lt;CFQUERYgt; tag are actually /FONTFONT = face=3DArial=20 size=3D22D arrays..."/FONT/DIV DIVFONT face=3DArial size=3D2The online docs say that "Query column = data can be=20 referenced using array-like syntax. For example, myquery.col_name[1] = references=20 data in the first row in the column col_name."/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2If the latter is true then it seems to = me that=20 queries are not acutally true 2D arrays but "arraylike" as it=20 says.../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I have tried accessing the query as a = true array=20 but I get an error.nbsp;Code and error are below, if anyone can clear = me up on=20 what I am missing I would be a very happy CF_programmer who can go home = finally,=20 becuase the damn project is due today and this is the last thing and = it's friday=20 and I have too much caffeine in me and i wont stop till I'm = done!/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2 H4Error Diagnostic Information/H4 PError resolving parameter BPRICEBREAKLOOP/B=20 P PColdFusion was unable to determine the value of the parameter. This = problem=20 is very likely due to the fact that either:=20 OL LIYou have misspelled the parameter name, or=20 LIYou have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, = or=20 CFTABLE tag./LI/OL P PThe error occurred while evaluating the expression:=20 PPRE pricebreaks[Major_Cat][looptracker] =3D = PriceBreakLoop[1][looptraker]/PREPREnbsp;/PREPREFONT = face=3DCourierlt;cfif
re: accessing a query as an array...reformatted
dont know why my query got all garbled but I hope this looks better cfif application.queryStatus IS 1 cfquery datasource="#productdsn#" name="PriceBreaksQuery" dbtype="ODBC" SELECT * FROM Pricing /cfquery cfset pricebreaks = ArrayNew(2) cfloop query="PriceBreaksQuery" cfquery datasource="#productdsn#" name="PriceBreaksLoop" dbtype="ODBC" SELECT * FROM Pricing WHERE Major_Cat = '#Major_Cat#' /cfquery cfset looptracker = 0 cfloop query="PriceBreaksLoop" cfset looptracker = (looptracker + 1) cfset pricebreaks[Major_Cat][looptracker] = PriceBreakLoop[1][looptraker] /cfloop /cfloop -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColdFusion and WAP!!!!!
hi.. I am trying to use coldfusion with wml using jataayu gateway on linux. My cf code is as follows.. ## cfcontent type="text/vnd.wap.wml" ?xml version="1.0"? !DOCTYPE wml PUBLIC "-//PHONE.COM//DTD WML 1.1//EN" "http://www.phone.com/dtd/wml11.dtd" wml card id="card1" title="cf-card" p hello how r u? /p /card /wml ## I am saving it as cfwml.cfm and trying to access it from a nokia simmmulator but unsuccessfully. But i am able to access the files with .wml extension in the same folder from nokia simmulator.As soon as i request the .cfm file from the simmulator , the gateway crashes... Is there any problem with my code? or do we need to configure the cfserver? or can it be the problem with the gateway? PLz try to help.. thanking suhail __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: accessing a query as an array
I am trying to populate an array from a query and I am running into = problems... From what I have infered from the CF docs, CFQuery's are actually = arrays.=20 If we assume that then, #QueryName[1][4]# should return the data in the = first row and the fourth column..right?? My confusion comes from what seems to me to be conflicting info in Ben = Forta's book and the CF online docs.=20 Ben states on page 529 (4.0) that "Database queries returned by the = CFQUERY tag are actually 2D arrays..." The online docs say that "Query column data can be referenced using = array-like syntax. For example, myquery.col_name[1] references data in = the first row in the column col_name." If the latter is true then it seems to me that queries are not acutally = true 2D arrays but "arraylike" as it says... Internally, queries are probably stored very much like two-dimensional arrays. I don't believe CF lets you address them like this, however. One of the problems is that there's no set order for the columns returned by a SQL query. That should be a bit more obvious when you do a SELECT *. Which database column would you expect the fourth column of the array to be? CF _will_ let you address each column as a one-dimensional array, as you've shown. Doing this lets you address the Nth row of the query randomly, rather than having to step through the query using cfloop. One simple way to populate a two-d array from a query is shown below. This way, you _know_ that 'name' is the first column, 'address' is the seconde, etc. cfset a = ArrayNew(2) cfloop query="myquery" cfset a[myquery.currentrow, 1] = myquery.name cfset a[myquery.currentrow, 2] = myquery.address cfset a[myquery.currentrow, 3] = myquery.city cfset a[myquery.currentrow, 4] = myquery.state cfset a[myquery.currentrow, 5] = myquery.zip /cfloop Depending on what you need to do with your array, you might also use an array of structs to keep the query results. An array of structs lets you address the columns by name, rather than by column number. Then again, there's no reason why you can't leave the data in the original CF query. There are CF function to let you manipulate the query data by adding rows, adding columns, and changing values. Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Random Record: methods
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] well what i want to be able to do is like show a random quote from a table of quotes Now some may be deleted, some may be added, in which the cfset Random = #RandRange(1, table.RecordCount)# would not work because the "ID" numbers in the table would be changing, is there a way to specify like a certain Row number in my SQL WHERE statement? Transfer the discontinuous list of id numbers to a continuous one. METHOD I cfquery name="getID" datasource="quotes" select ID from quoteTable where 0=0; cfset id_domain=ArrayNew(1) cfloop query="getID" cfset id_domain[CurrentRow]=ID /cfloop cfset temp=Randomize(DatePart("s", Now())) cfset randomID= randrange(1, ArrayLen(id_domain)) cfquery name="getQuote" datasource="quotes" select QUOTE from quoteTable where ID='#randomID#' METHOD II cfquery name="getID" datasource="quotes" select ID from quoteTable where 0=0; cfset temp=Randomize(DatePart("s", Now())) cfset randomID= randrange(1, getID.RecordCount) cfquery name="getQUOTE" datasource="quotes" select QUOTE from quoteTable where ID='#getID.ID[randomID]#' /cfquery Often an intractable problem involving a domain of elements that aren't suspectible to simple analyses is resolvable by abstracting one, or more, level(s) away from the domain. Works for lots of problems. The first example shows an explicit transfer of seemingly disorganized data to a nice monotonically increasing ordered domain of id numbers that starts with 1 and ends with the count of all possible id numbers that we select randomly from in order to point at a record in the quotes db. The second example implicitly uses the inherent simple ordering of a query for the same purpose. In both examples we end up not caring what gets done to the list of id numbers in the quotes db - we can still accomplish our goal. As a further note: if editing of the quoteTable is done in a way that always leaves only returnable items in the table then Method II will always work and the benefit of not using an array accrues. If editing of the quoteTable is done such that some quotes are marked as temporarily non-returnable, then Method I would work better as the array can be built from a query that gets both ID and a field used to mark a quote as currently useable or un-useable. Thus, in the cfloop that assigns ID numbers to the array we can test for the value of the second field and make the assignment or not as indicated. METHOD I - extended [assume quotes.quoteTable.useThisQuote is boolean or is some other two-valued field] cfquery name="getID" datasource="quotes" select ID, useThisQuote from quoteTable where 0=0; cfset id_domain=ArrayNew(1) cfset id_index=1 cfloop query="getID" cfif(useThisQuote IS NOT "NO") cfset id_domain[id_index]=ID /cfif cfset id_index=id_index + 1 /cfloop cfset temp=Randomize(DatePart("s", Now())) cfset randomID= randrange(1, ArrayLen(id_domain)) cfquery name="getQuote" datasource="quotes" select QUOTE from quoteTable where ID='#randomID#' As a final further note: what I would actually do in this kind of case is use a stored query in the quotes db that lets the db do the work of most of Methods I and II. Method III (Build a query in db that creates a list comprised of all IDs that are currently useable or otherwise selected.) then, use Method II querying the stored query from the quotes table and so on ... This allows for the easy use of several stored queries that are built according to different purposes - such as randomly selecting a quote from a disorganized group of ids, selecting from a group of ids currently marked as useable, selecting from a group of ids related to a specific topic or user or date, etc. Pan 'currently available for hire' -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: accessing a query as an array
Thank you Jim! You realize though that you have said Ben Forta is wrong...I wouldn't be standing in the middle of any fields during a thunderstorm if I were you. :-) jon - Original Message - From: "Jim McAtee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:21 AM Subject: Re: accessing a query as an array I am trying to populate an array from a query and I am running into = problems... From what I have infered from the CF docs, CFQuery's are actually = arrays.=20 If we assume that then, #QueryName[1][4]# should return the data in the = first row and the fourth column..right?? My confusion comes from what seems to me to be conflicting info in Ben = Forta's book and the CF online docs.=20 Ben states on page 529 (4.0) that "Database queries returned by the = CFQUERY tag are actually 2D arrays..." The online docs say that "Query column data can be referenced using = array-like syntax. For example, myquery.col_name[1] references data in = the first row in the column col_name." If the latter is true then it seems to me that queries are not acutally = true 2D arrays but "arraylike" as it says... Internally, queries are probably stored very much like two-dimensional arrays. I don't believe CF lets you address them like this, however. One of the problems is that there's no set order for the columns returned by a SQL query. That should be a bit more obvious when you do a SELECT *. Which database column would you expect the fourth column of the array to be? CF _will_ let you address each column as a one-dimensional array, as you've shown. Doing this lets you address the Nth row of the query randomly, rather than having to step through the query using cfloop. One simple way to populate a two-d array from a query is shown below. This way, you _know_ that 'name' is the first column, 'address' is the seconde, etc. cfset a = ArrayNew(2) cfloop query="myquery" cfset a[myquery.currentrow, 1] = myquery.name cfset a[myquery.currentrow, 2] = myquery.address cfset a[myquery.currentrow, 3] = myquery.city cfset a[myquery.currentrow, 4] = myquery.state cfset a[myquery.currentrow, 5] = myquery.zip /cfloop Depending on what you need to do with your array, you might also use an array of structs to keep the query results. An array of structs lets you address the columns by name, rather than by column number. Then again, there's no reason why you can't leave the data in the original CF query. There are CF function to let you manipulate the query data by adding rows, adding columns, and changing values. Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion SP2
Oh yeah! I almost forgot a really obvious one... That when an RDS connection to another machine fails, that it doesn't take Studio with it. I regularly have to Ctrl-Alt-Del to close Studio when RDS has a problem of one sort or another. -- 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error creating Verity collection
Steve, This error ususally occurs when you try to create a collection that already exsists. If you have been deleting mapped collections, CF only deletes the mapping, not the collection, you would need to physically delete the structure. Remember, that the names of collections need to be unique, through-out the entire 'collections' structure. Hope this helps Richard -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 October 2000 12:26 To: CF-Talk Subject: Error creating Verity collection I have been happily creating and deleting Verity collections for a few days now either via the Administrator or code (CF 4.5, NT Server). However, when I try to create a collection now I am given the error message "Error creating Verity collection". I have deleted all the collections, but CF still refuses to play ball. Any suggestions? Thanks Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Random Record
I use the database for that (better? I think ): SELECT count(*) total, (ceiling((RAND( (DATEPART(ms, GETDATE()) * 10 )+ (DATEPART(ss, GETDATE()) * 1000 )+ DATEPART(mm, GETDATE()) ))*count(*))) rand FROM YourTable It gives you one record, something like: totalRand - 1100120.0 record selected: 120 ~Juandres - Original Message - From: Lee Borkman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 06, 2000 7:24 PM Subject: RE: Random Record Guys, this will only work if the IDs start at 1, and there are no missing IDs. Also, the #s are unnecessary in your CFSET. Have fun, Lee. Bjork.Net [EMAIL PROTECTED] (Brian bouldernet) wrote: x = total available records cfset RandomCount = #RandRange(1,x)# cfquery SELECT * FROM TABLE WHERE ID = Random Count /cfquery -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 4:49 PM To: CF-Talk Subject: Random Record How could i select a random record from a table? Like to set my query as cfquery datasource="mine" name="selectrandomrecord" SELECT * FROM Table WHERE RecordID = ?? cfquery Anyone know how to do this? thanks kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Parsing, and assigning variables.
Parsing a returned value set. I am getting something like" bName:nbsp;/b/tdtd align=leftJoe Smith/td/tr trtd align=right valign=topbnbsp;nbsp;/b/tdtd align=leftnbsp;/td/tr trtd align=right valign=topbCompany:nbsp;/b/tdtd align=leftJoe Blow Tires /td/tr" sen to me... is ther a way to parse out everyiny thing but : Name: Joe Smite Company: Joe Blow Tires The left amount of character before the first is dyanmic so I don't see how I could take off the left? The major goal is to have Joe Smit and Joe Blow Tires end up as variable.. Thanks, Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion SP2
I regularly have to Ctrl-Alt-Del to close Studio when RDS has a problem of one sort or another. I had to reinstall Studio completely (including altering Registry settings manually!) after I had set a directory under a remote RDS CFserver to be the default directory that was opened when Studio was started up. The IP of the machine had to be changedblammo - Studio dead forever. Needless to say I wasn't impressed. It is such a buggy peice of software. But when it works, it rocks! --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:36 AM To: CF-Talk Subject: Re: ColdFusion SP2 Oh yeah! I almost forgot a really obvious one... That when an RDS connection to another machine fails, that it doesn't take Studio with it. I regularly have to Ctrl-Alt-Del to close Studio when RDS has a problem of one sort or another. -- 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=listsbody=list s/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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IBM, Allaire Singled Out For Annual Report Card Honors
This is obviously excellent news, and a credit to Allaire. Allaire should most definitely send this out on the financial wires as a news release - their beleagured investors could use all the good news they can get right about now! Adrian Cooper. - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 10:41 PM VARBusiness recognized Allaire as one of the technology industry powerbrokers of the new economy during its Annual Report Card (ARC) awards ceremony held September, 2000. Awarded "Breakthrough Player of the Year," Allaire also took top honors in the Internet Software and Enterprise Development Tools categories. Competition included well-established companies, such as IBM, Borland/Inprise, Microsoft, Oracle, and Sybase. Allaire was chosen for its strong performance coupled with high scores in product availability, communication, revenue/profit potential, channel strategy, and ease of doing business. Held annually, the ARC awards are given to a select group of companies who provide unmatched vendor satisfaction in products, support, and partnership. More than 5,000 New Economy digital business architects were surveyed to determine the winners. See: http://www.varbusiness.com/Sections/News/BreakingNews.asp?ArticleID=20419 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Kinda OT : Java based file uploader
I want a (nearly) free java applet that I can put on a page that will pop up a file requester when a button is clicked and upload the file chosen (with progress bar/something) to a (not necesarily) CF template on site. Preferably the applet would invoke some javascript function with appropriate attributes when the upload is complete so that page content (say an image) could be updated right before the users eyes. I looked into writing this myself, and indeed had a prototype (which didn't actually transfer stuff) running in applet viewer before I realised that to get it working everywhere I would have to fork out to get a certificate to sign the classes so that a file requester could be opened in a browser. Anybody know if such a beast exists ? --- James Sleeman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio vs. HomeSite
Think of Studio as HomeSite on steroids! 8-) Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 5:34 PM Subject: RE: Studio vs. HomeSite HomeSite is excellent for HTML work. CF Studio is virtually the same but geared toward CF development with RDS, and the context sensitive help (it's costs more too). -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 October 2000 4:51 To: CF-Talk Subject: Studio vs. HomeSite Does anyone have any preferences for one over the other? What does one do that the other does not? What is the diff?? Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Server security
CF 4.0.1, NT4, SQL Server 7.0 (possibly a dumb Q, but I gotta ask it anyway) Which would be more secure: (i) putting the username and password in every CFQUERY tag that reads/writes to the SQL Server database, or (ii) providing the username and password in the ODBC Data Source config? ...and does it matter? I'm thinking if someone unearths another security hole like ::$DATA or .+htr, with the username and password in the template, (i) gives them the username/password combo, but if they managed to upload templates to the server using (ii) means they don't need to provide it in the template. Suggestions? Thanks for any advice. -- 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Random Record
From: "Juan Andres Alvarez Valenzuela" [EMAIL PROTECTED] I use the database for that (better? I think ): SELECT count(*) total, (ceiling((RAND( (DATEPART(ms, GETDATE()) * 10 )+ (DATEPART(ss, GETDATE()) * 1000 )+ DATEPART(mm, GETDATE()) ))*count(*))) rand FROM YourTable It gives you one record, something like: totalRand - 1100120.0 record selected: 120 That's a good method for generating a random number in the range of the count of records in a table, but how does this provide any pointer to a specific row in that table? It works if you subsequently query all records of YourTable and then references query[120], but the overhead is higher in both memory and processing time. Also, count(*) will catch nulls which will (if there are any) invalidate the range for selecting a random number. The second query after generating a random should be as quick and efficient as possible - selecting all data from a table and then referencing query[random] can take more time and memory than a second query that selects one specific row. Also, rand() generates an error for MS-Access - need to use rnd(), but there is no way to seed rnd() in a sql statement for Access. The random number needs to be built outside the query. Pan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Realsim and 4D Arrays
How about a cube moving thru time ... then each one of those little cubes would have x,y,z at any giving point in time. The cube with a velocity moving thru time ... yeap, I think that'll do it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Parsing, and assigning variables.
From: "Brian bouldernet" [EMAIL PROTECTED] Parsing a returned value set. I am getting something like" bName:nbsp;/b/tdtd align=leftJoe Smith/td/tr trtd align=right valign=topbnbsp;nbsp;/b/tdtd align=leftnbsp;/td/tr trtd align=right valign=topbCompany:nbsp;/b/tdtd align=leftJoe Blow Tires /td/tr" sen to me... is ther a way to parse out everyiny thing but : Name: Joe Smite Company: Joe Blow Tires The left amount of character before the first is dyanmic so I don't see how I could take off the left? The major goal is to have Joe Smit and Joe Blow Tires end up as variable.. Long way - parse unwanted html (i.e. all of the '/b','td align="left"', etc.) using replace functions to "" leaving you with Name:JoeSmithCompany:Joe Blow Tires. You should be able to construct two vars out of that easily enough. Shorter way - should be able to regex out exactly what you want. Don't have time to build it for you right now, maybe someone else can. Hope this helps some ... Pan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Server Decimal
I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
Either way it doesn't work (I've tried both and it's just wierd). There isn't an error as such. The field just discard everything after the dot. Should I be using a scientific format ie 361*10^-2 or something like that? Paul PS I even tried CFQUERYPARAM and that didn't work either. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Realsim and 4D Arrays
imagine the tardis. with Dr. Who flying through space time. 3-demensional on the out side, but infinite within. just messing. -paul -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 8:07 AM To: CF-Talk Subject: Re: Realsim and 4D Arrays How about a cube moving thru time ... then each one of those little cubes would have x,y,z at any giving point in time. The cube with a velocity moving thru time ... yeap, I think that'll do it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
Paul Try running the query in ISQL (query Analyser) replacing the variables with the values. See what gets inserted into the table. If the correct values get inserted the put some debugging code in your cfm templates to output the values of the variables before you run the query so you can see exactly what is being passed in -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:39 To: CF-Talk Subject: RE: SQL Server Decimal Either way it doesn't work (I've tried both and it's just wierd). There isn't an error as such. The field just discard everything after the dot. Should I be using a scientific format ie 361*10^-2 or something like that? Paul PS I even tried CFQUERYPARAM and that didn't work either. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
Paul Take a step back mate..what is getting put into the SQL table? If the wrong data is getting put in there run the same query through ISQL and see what happens -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:44 To: CF-Talk Subject: RE: SQL Server Decimal By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Script
hello all! what is a good referance to learn CF_Script? What URL's do you have? i would like to know why you would or would not use it. what are its benifits? i have noticed that Ultra_Dev uses it alot in its pages. Thank You. -paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server Decimal
Actually, I change the field to a float and it's fine! Sorry to bother everyone with that one, although I do think that a data type of "decimal" should be able to hold a "decimal" number! Whoever decided it shouldn't, was a stupid person. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:55 To: CF-Talk Subject: RE: SQL Server Decimal Paul Take a step back mate..what is getting put into the SQL table? If the wrong data is getting put in there run the same query through ISQL and see what happens -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:44 To: CF-Talk Subject: RE: SQL Server Decimal By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fw: CF Script
what is a good referance to learn CF_Script? What URL's do you have? CfScript is a hack of Javascript, There is not much to it. All the CF functions work the same. It's only really the control structures that are different. So if you know JavaScript you will know CFScript (with a few exceptions) what are its benifits? It is faster and easy to read in some cases Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Script
I don't know of any sites with CFScript tutorials, but I can tell you that the only times I find myself using it, are when I feel more comfortable writing a 'for' loop (java syntax), or when I need to declare several variables in one place. You can do much more with it if you want, but these are the scenarios when I find myself using it most. ~Simon -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:06 AM To: CF-Talk Subject: CF Script hello all! what is a good referance to learn CF_Script? What URL's do you have? i would like to know why you would or would not use it. what are its benifits? i have noticed that Ultra_Dev uses it alot in its pages. Thank You. -paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Once In A Lifetime Photo
This is a multi-part message in MIME format. --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit You have got to see this. The caption below the photo explains all. Enjoy, Dave http://www.boortz.com/FireElk.htm --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: application/octet-stream; name="FireElk.url" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="FireElk.url" [DEFAULT] BASEURL=http://www.boortz.com/FireElk.htm [InternetShortcut] URL=http://www.boortz.com/FireElk.htm Modified=00CE3955982FC001E4 --=_NextPart_000_0012_01C02F77.2AAD7B80-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server security
IMO: putting the username and password in every CFQUERY tag is asking for trouble. I am going to guess that not every one has the luxury, as I do, of being able to delete all the users form the server but one or two. I and three other "team" members are the only ones that have access to my servers. I would say do not put the user name and pass in the CFQUERY and make sure your server is secure. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 6:23 AM To: CF-Talk Subject: SQL Server security CF 4.0.1, NT4, SQL Server 7.0 (possibly a dumb Q, but I gotta ask it anyway) Which would be more secure: (i) putting the username and password in every CFQUERY tag that reads/writes to the SQL Server database, or (ii) providing the username and password in the ODBC Data Source config? ...and does it matter? I'm thinking if someone unearths another security hole like ::$DATA or .+htr, with the username and password in the template, (i) gives them the username/password combo, but if they managed to upload templates to the server using (ii) means they don't need to provide it in the template. Suggestions? Thanks for any advice. -- 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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Random Record
What about this: cfquery name="getMaxId" DATASOURCE="yourDSN" SELECT MAX(RecordID) AS MaxID FROM TABLE /cfquery cfset RandNum = #RandRange(1,getMaxID.MaxID)# cfquery datasource="mine" name="selectrandomrecord" SELECT * FROM Table WHERE RecordID = #RandNum# cfquery Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 6:49 PM To: CF-Talk Subject: Random Record How could i select a random record from a table? Like to set my query as cfquery datasource="mine" name="selectrandomrecord" SELECT * FROM Table WHERE RecordID = ?? cfquery Anyone know how to do this? thanks kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Random Record
If that's the case just do this: cfquery name="selectrandomrecord" datasource="MINE" SELECT * FROM QUOTES /cfquery cfset RandNum = #RandRange(1,selectrandomrecord.RecordCount)# CFLOOP QUERY="selectrandomrecord" CFIF CurrentRow EQ #RandNum# CFOUTPUT Random Record No = #selectrandomrecord.ID#BR Quote = #selectrandomrecord.Quote#BR Author = #selectrandomrecord.Author# /cfoutput /cfif /cfloop Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 10:52 PM To: CF-Talk Subject: Re: Random Record well what i want to be able to do is like show a random quote from a table of quotes Now some may be deleted, some may be added, in which the cfset Random = #RandRange(1, table.RecordCount)# would not work because the "ID" numbers in the table would be changing, is there a way to specify like a certain Row number in my SQL WHERE statement? like... cfquery datasource="ds" name="random" SELECT * FROM Quotes WHERE ***TableRow = Random Row*** /cfquery can that type of function be completed??? kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Creating graph objects
Hi all, I have to create charts (bars, pies,...) on **printable** pages, using data from SQLServer 7.0. Do someone know a freeware or a low price product able to generate Chart or jpg images ? TIA, Denis -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: verisign payflow link?
Has anyone called a Win .EXE file from a html page? On our intranet, we want to recreate a VB navigational menu system that calls other VB applications (the VB applications reside on a drive that has been mapped on our end users computers). How can I do this? Paul Sizemore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Once In A Lifetime Photo
friggin incredible! my fiance sent that to me a few days ago. i couldnt imagine. going camping in 2 weeks! -Original Message- From: Dave Hannum [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:24 AM To: CF-Talk Subject: OT: Once In A Lifetime Photo This is a multi-part message in MIME format. --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit You have got to see this. The caption below the photo explains all. Enjoy, Dave http://www.boortz.com/FireElk.htm --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: application/octet-stream; name="FireElk.url" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="FireElk.url" [DEFAULT] BASEURL=http://www.boortz.com/FireElk.htm [InternetShortcut] URL=http://www.boortz.com/FireElk.htm Modified=00CE3955982FC001E4 --=_NextPart_000_0012_01C02F77.2AAD7B80-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Random Record
yep... You're rigth pan. I will change my programs... thanks! ~Juandres - Original Message - From: pan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 06, 2000 2:04 PM Subject: Re: Random Record From: "Juan Andres Alvarez Valenzuela" [EMAIL PROTECTED] I use the database for that (better? I think ): SELECT count(*) total, (ceiling((RAND( (DATEPART(ms, GETDATE()) * 10 )+ (DATEPART(ss, GETDATE()) * 1000 )+ DATEPART(mm, GETDATE()) ))*count(*))) rand FROM YourTable It gives you one record, something like: totalRand - 1100120.0 record selected: 120 That's a good method for generating a random number in the range of the count of records in a table, but how does this provide any pointer to a specific row in that table? It works if you subsequently query all records of YourTable and then references query[120], but the overhead is higher in both memory and processing time. Also, count(*) will catch nulls which will (if there are any) invalidate the range for selecting a random number. The second query after generating a random should be as quick and efficient as possible - selecting all data from a table and then referencing query[random] can take more time and memory than a second query that selects one specific row. Also, rand() generates an error for MS-Access - need to use rnd(), but there is no way to seed rnd() in a sql statement for Access. The random number needs to be built outside the query. Pan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to call an .EXE from web page
cfexecute in CF4 + otherwise look at www.intrafoundation.com for cfx_consolecommand , cfx_spawn etc... Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:11 PM Subject: OT: How to call an .EXE from web page Has anyone called a Win .EXE file from a html page? On our intranet, we want to recreate a VB navigational menu system that calls other VB applications (the VB applications reside on a drive that has been mapped on our end users computers). How can I do this? Paul Sizemore -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
dynamically filling a calendar
Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Once In A Lifetime Photo
I was going to gripe about how off topic this is... but it really is a beautiful photo... At 09:24 AM 10/6/00 -0400, Dave Hannum wrote: This is a multi-part message in MIME format. --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit You have got to see this. The caption below the photo explains all. Enjoy, Dave http://www.boortz.com/FireElk.htm --=_NextPart_000_0012_01C02F77.2AAD7B80 Content-Type: application/octet-stream; name="FireElk.url" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="FireElk.url" [DEFAULT] BASEURL=http://www.boortz.com/FireElk.htm [InternetShortcut] URL=http://www.boortz.com/FireElk.htm Modified=00CE3955982FC001E4 --=_NextPart_000_0012_01C02F77.2AAD7B80-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Kinda OT : Java based file uploader
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I want a (nearly) free java applet that I can put on a page that will pop up a file requester when a button is clicked and upload the file chosen (with progress bar/something) to a (not necesarily) CF template on site. Preferably the applet would invoke some javascript function with appropriate attributes when the upload is complete so that page content (say an image) could be updated right before the users eyes. I looked into writing this myself, and indeed had a prototype (which didn't actually transfer stuff) running in applet viewer before I realised that to get it working everywhere I would have to fork out to get a certificate to sign the classes so that a file requester could be opened in a browser. Anybody know if such a beast exists ? To the best of my knowledge, a Java *applet* can not read or write any files on the client's hard disk. That's a security thing, otherwise... Well I'm sure you can see the nasty security implications of a webpage being able to read or write users' files A Java application could do what you seek, but that can't be embedded in a browser. We ran into the same problem going in the oposite direction -- our users want to batch download files from our site. We've started implmenting it as an ActiveX component in VB. It's not cross platform, or course, but as far as I know, it's the only way to access users' file systems. Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOd3hNQraVoMWBwRBEQKlngCdE7Yd6L/0o8NCkAR3GhS55EFqQC0AoJK2 sWto7DinuxAlhPTLtWm6Uujx =DZPY -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Realsim and 4D Arrays
Maybe its because I don't exist in some Sci-Fi Channel tv show, but I'm having a hard time thinking of what a 4D Array looks like. 1d = X cordinate 2d = X,Y cordinate 3d = X,Y,Z cordinate 4d = bah! Considering a 1d array is a line, a 2d is a plane, 3d is a cube, would 4d then in this sense, be 1 cube seperated by several smaller cubes wich are in turn seperated by even smaller cubes? or is it just not safe to go there? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
Oo, me too, pleassse :) Could you include me in on that colander code (possibly post it to the list?) Kevin Queen Software Engineer Synthetic Logic "Ah, I see!", said the blind man to the deaf mute. -Unknown -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:36 AM To: CF-Talk Subject: Re: dynamically filling a calendar Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
I also would like the code -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 10:36 AM To: CF-Talk Subject: Re: dynamically filling a calendar Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
Please doalso, is there somewhere i can view the article? On Fri, 06 Oct 2000, Kevin Schmidt spake thusly: Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
colander code? Are we cooking here? ;-) - Original Message - From: "Kevin Queen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 10:38 AM Subject: RE: dynamically filling a calendar Oo, me too, pleassse :) Could you include me in on that colander code (possibly post it to the list?) Kevin Queen Software Engineer Synthetic Logic "Ah, I see!", said the blind man to the deaf mute. -Unknown -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:36 AM To: CF-Talk Subject: Re: dynamically filling a calendar Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
Yes, post it to the list please. I am in desperate need of something that does exactly that :) Todd Ashworth - Original Message - From: "Kevin Queen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 10:38 AM Subject: RE: dynamically filling a calendar | Oo, me too, pleassse :) | | Could you include me in on that colander code (possibly post it to the | list?) | | Kevin Queen | Software Engineer | Synthetic Logic | | | "Ah, I see!", said the blind man to the deaf mute. -Unknown | | | -Original Message- | From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] | Sent: Friday, October 06, 2000 11:36 AM | To: CF-Talk | Subject: Re: dynamically filling a calendar | | | Jon, | | I just finished writing an article for CFDJ on this very thing. I would be | more than willing to send you the code that generates the calendar as well | as populates it from a Database of events. | | Kevin | - Original Message - | From: "Jon Tillman" [EMAIL PROTECTED] | To: "CF-Talk" [EMAIL PROTECTED] | Sent: Friday, October 06, 2000 9:24 AM | Subject: dynamically filling a calendar | | | Hey folks, | I have a calendar(as part of a scheduling app) that I need to fill in | dynamically. | What I am trying to do is to allow the user to select any month in any | year and | have the table filled out with the correct "month view" layuot. | Is there a way to compare the results of the DateFormat() function OR a | variable to the position of the table cell (both row and column) so as to | determine where the individual dates should be? | | Any help would be greatly appreciated. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server security
IMO: putting the username and password in every CFQUERY tag is asking for trouble. [snip] OK, will do. Thanks for the advice. -- 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call an .EXE from web page
Doesn't CFExecute execute a on the server? And, it looks like the others do as well (but, Intra tools looks to have great products). I need to run a VB app on the end user's machine. (Like CF C:\Windows\ Calc.exe) -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:20 AM To: CF-Talk Subject: Re: How to call an .EXE from web page cfexecute in CF4 + otherwise look at www.intrafoundation.com for cfx_consolecommand , cfx_spawn etc... Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:11 PM Subject: OT: How to call an .EXE from web page Has anyone called a Win .EXE file from a html page? On our intranet, we want to recreate a VB navigational menu system that calls other VB applications (the VB applications reside on a drive that has been mapped on our end users computers). How can I do this? Paul Sizemore -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Realsim and 4D Arrays
http://206.183.250.42/flash/bwCubes.swf -Original Message- From: Gavin Myers [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 8:49 AM To: CF-Talk Subject: Realsim and 4D Arrays Maybe its because I don't exist in some Sci-Fi Channel tv show, but I'm having a hard time thinking of what a 4D Array looks like. 1d = X cordinate 2d = X,Y cordinate 3d = X,Y,Z cordinate 4d = bah! Considering a 1d array is a line, a 2d is a plane, 3d is a cube, would 4d then in this sense, be 1 cube seperated by several smaller cubes wich are in turn seperated by even smaller cubes? or is it just not safe to go there? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Kinda OT : Java based file uploader
It is possible with a Java applet, but I don't know of any free ones. Try the standard applet repositories (Gamelan, etc.) I assume that even if you were to find free source for one, you'd still have to buy a certificate or set up your own certificate authority thingy. Equifax is pretty cheap for that kind of stuff I think, but I'm not up on the market. ;) Good luck! Ed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL question
Try this: select top 1 userID, count(course) from tablename group by userid order by 2 desc select top 1 course, count(userid) from tablename group by course order by 2 desc -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 8:03 PM To: CF-Talk Subject: SOT: SQL question -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In a table something like this: userid, course john ethics john english mary english mary math mary bio I need to find a) which user has taken the most courses in total b) which course was taken the most often Ideas? c -BEGIN PGP SIGNATURE- Version: 6.5.8ckt http://irfaiad.virtualave.net/ Comment: PGP Signed for message verification and/or encryption Comment: KeyID: 0xD68B61E851046CFD iQA/AwUBOd0ksNaLYehRBGz9EQJjVQCfUA600RImF5Y7NRoha4BGnHzrV/QAoKWx 9BIcf5UEne847/fTRg/Ryv/y =CpJ4 -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
The article will most likely appear in the December issue of Cold Fusion Developers Journal or possible the January issue depending on their size constraints. To all who have requested the code I will send it out this afternoon. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:47 AM Subject: Re: dynamically filling a calendar Please doalso, is there somewhere i can view the article? On Fri, 06 Oct 2000, Kevin Schmidt spake thusly: Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
The CF date functions make this kind of stuff really, really easy. I made a calendar app a few months ago to pass the time while waiting for a contract with eCal to be signed. It ended up being far better than eCal's app, but we didn't really need a calendar in the end. If I remember, the most difficult thing was figuring out how to deal with months that start on Friday, months with 29 days, etc... which wasn't really too bad. ;) Some useful functions: CreateDate(year, month, day) FirstDayOfMonth(date) DaysInMonth(date) DateAdd(datepart, number, date) Ed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02FA7.3FA4E930 Content-Type: text/plain; charset="iso-8859-1" At risk of sounding like I am jumping on the "I'd like the code/article too," bandwagon (gee what was that sound) I would love to see/have/covet same! Jon Moneymaker (and yes, that really is my last name) Programmer and Web Designer Hopeful/Wannabe -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:36 AM To: CF-Talk Subject: Re: dynamically filling a calendar Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C02FA7.3FA4E930 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35" TITLERE: dynamically filling a calendar/TITLE /HEAD BODY PFONT SIZE=3D2At risk of sounding like I am jumping on the = quot;I'd like the code/article too,quot; bandwagon (gee what was that = sound)/FONT/P PFONT SIZE=3D2I would love to see/have/covet same!/FONT /P PFONT SIZE=3D2Jon Moneymaker (and yes, that really is my last = name)/FONT BRFONT SIZE=3D2Programmer and Web Designer Hopeful/Wannabe/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Kevin Schmidt [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Friday, October 06, 2000 11:36 AM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: Re: dynamically filling a calendar/FONT /P BR PFONT SIZE=3D2Jon,/FONT /P PFONT SIZE=3D2I just finished writing an article for CFDJ on this = very thing.nbsp; I would be/FONT BRFONT SIZE=3D2more than willing to send you the code that = generates the calendar as well/FONT BRFONT SIZE=3D2as populates it from a Database of events./FONT /P PFONT SIZE=3D2Kevin/FONT BRFONT SIZE=3D2- Original Message -/FONT BRFONT SIZE=3D2From: quot;Jon Tillmanquot; = lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2To: quot;CF-Talkquot; = lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2Sent: Friday, October 06, 2000 9:24 AM/FONT BRFONT SIZE=3D2Subject: dynamically filling a calendar/FONT /P BR PFONT SIZE=3D2gt; Hey folks,/FONT BRFONT SIZE=3D2gt; I have a calendar(as part of a scheduling app) = that I need to fill in/FONT BRFONT SIZE=3D2gt; dynamically./FONT BRFONT SIZE=3D2gt; What I am trying to do is to allow the user to = select any month in any/FONT BRFONT SIZE=3D2year and/FONT BRFONT SIZE=3D2gt; have the table filled out with the correct = quot;month viewquot; layuot./FONT BRFONT SIZE=3D2gt; Is there a way to compare the results of the = DateFormat() function OR a/FONT BRFONT SIZE=3D2gt; variable to the position of the table cell = (both row and column) so as to/FONT BRFONT SIZE=3D2gt; determine where the individual dates should = be?/FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; Any help would be greatly appreciated./FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; --/FONT BRFONT SIZE=3D2gt; =
RE: dynamically filling a calendar
I wouldn't mind a copy of that also. Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:02 AM To: CF-Talk Subject: Re: dynamically filling a calendar The article will most likely appear in the December issue of Cold Fusion Developers Journal or possible the January issue depending on their size constraints. To all who have requested the code I will send it out this afternoon. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:47 AM Subject: Re: dynamically filling a calendar Please doalso, is there somewhere i can view the article? On Fri, 06 Oct 2000, Kevin Schmidt spake thusly: Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle Cold Fusion $1 million dollars
First of all, thanks for all the great advice on oracle and cold fusion integration. Secondly, Oracle is THE database company. That is how it got to be the 2nd largest software company in the world(microsoft 1st, veritas 3rd). Oracle 9i, which was showcased at Oracle Openworld here last wednesday, is quite amazing, at least according to the demo. :o) Its performance was so fast in fact, that Larry Ellison said that he'd pay $1 million to anybody who could show a Microsoft database performing anything less than 3X slower than an Oracle database. Plus they are super integrated with Solaris, which is always highly appreciated for those concerned about the enterprise level. Has anybody heard about SuSE's integration with Oracle? They are supposed to be the leading Linux flavor supporting it. Can anybody comment on MySQL speeds compared to SQL Server and Oracle? BTW, on the topic of which, anybody seen Google? Of course. Damn that site is a fast loader and responder!!! Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
I recently wrote a calendar application that allows Day, Week, Month, Year with events scheduled per day. The trickiest part was setting up the months to look like an actual month. That is to start your day in which table column. Like if your month starts on a Friday then the first has to show up on a Friday. There is a really easy way to achieve this, and after I figured out this part it was a cake walk:) It is the DayOfWeek function :) So say your date 10.1.00 which happens to fall on saturday, so this would return 1 which means your offset for that day is one, meaning it belongs in the first column. try it with 11.1.00 which falls on a Wednesday DayOfWeek returns 4 for this date meaning your day belongs in the 4th column. :) This avoids doing any complex logic to figure this out. Basically you can display a calendar month with only one loop with x iterations (x being the number of days in the month) which makes it rather effecient ( I then had one more inner loop to handle checking for events ) So I was pleased with the speed of the calendar I have seen some that were terribly slow :) Here is a little snippet so you guys dont maul me :P Also with this logic you can figure out how many days the end will be by figuring out the day of the week for the last day in the month. That is pretty much all of the tricky stuff to doing a calendar, year views are easy since you already have a nice tight way to display months. So as Ed said its eeasy :) Ive written equivalent stuff in C and the math can drive you insane, really really CF has some of the nicest date functions around. Jeremy Allen [EMAIL PROTECTED] -Original Message- From: Ed Toon [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:05 AM To: CF-Talk Subject: RE: dynamically filling a calendar The CF date functions make this kind of stuff really, really easy. I made a calendar app a few months ago to pass the time while waiting for a contract with eCal to be signed. It ended up being far better than eCal's app, but we didn't really need a calendar in the end. If I remember, the most difficult thing was figuring out how to deal with months that start on Friday, months with 29 days, etc... which wasn't really too bad. ;) Some useful functions: CreateDate(year, month, day) FirstDayOfMonth(date) DaysInMonth(date) DateAdd(datepart, number, date) Ed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to call an .EXE from web page
Oh Sorry ! No you can oly do this using a Java Applet or ActiveX control Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:53 PM Subject: RE: How to call an .EXE from web page Doesn't CFExecute execute a on the server? And, it looks like the others do as well (but, Intra tools looks to have great products). I need to run a VB app on the end user's machine. (Like CF C:\Windows\ Calc.exe) -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:20 AM To: CF-Talk Subject: Re: How to call an .EXE from web page cfexecute in CF4 + otherwise look at www.intrafoundation.com for cfx_consolecommand , cfx_spawn etc... Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:11 PM Subject: OT: How to call an .EXE from web page Has anyone called a Win .EXE file from a html page? On our intranet, we want to recreate a VB navigational menu system that calls other VB applications (the VB applications reside on a drive that has been mapped on our end users computers). How can I do this? Paul Sizemore -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
WAP, Cold Fusion and Palm Pilot OS Development
Neko Media is interested in talking with people about WAP and Cold Fusion. We are currently doing work integrating our Palm Pilot Apps with the Web and Cold Fusion. If you have any insight into this, I would love to talk with you. Donovan [EMAIL PROTECTED] -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Going Insane...IIF
Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfelse''/cfif ERROR- An error occurred while evaluating the expression: #IIF(Len(conv_data.BankingSpecificLoansDeposits),conv_data.BankingSpecificLoansDeposits,DE(''))# Error near line 428, column 6. An error has occurred while processing the expression: The reason for the error is unknown. The error occurred while processing an _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
I would also like the code. Winston - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:02 AM Subject: Re: dynamically filling a calendar The article will most likely appear in the December issue of Cold Fusion Developers Journal or possible the January issue depending on their size constraints. To all who have requested the code I will send it out this afternoon. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:47 AM Subject: Re: dynamically filling a calendar Please doalso, is there somewhere i can view the article? On Fri, 06 Oct 2000, Kevin Schmidt spake thusly: Jon, I just finished writing an article for CFDJ on this very thing. I would be more than willing to send you the code that generates the calendar as well as populates it from a Database of events. Kevin - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 9:24 AM Subject: dynamically filling a calendar Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
A list of known security holes?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/plain; charset="iso-8859-1" Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVSPAN class=781032715-06102000FONT face=Arial size=2Hello all;/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2I recently came across the .+htr hole and am wondering about any other things that should be looked at./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Thanks/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Nadir/FONT/SPAN/DIV/BODY/HTML --_=_NextPart_001_01C02FAA.59D650C2-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
I'd like to see it as well. tom The article will most likely appear in the December issue of Cold Fusion Developers Journal or possible the January issue depending on their size constraints. To all who have requested the code I will send it out this afternoon. Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOBJECT Sessions
I'm using a COM object to parse an XML doc: cfobject action="CREATE" class="Microsoft.XMLDom" type="COM" name="xmlDoc" That works fine as long as I only have one page. But once I've loaded the document, I want to keep it in memory across pages. I put it in a session variable: Session.xmlDoc = xmlDoc; and in the next page, when I do cfif isDefined("Session.xmlDoc") EQ "true" I get the right answer. BUT, I can't access any of the object's properties. Error resolving parameter XMLDOC.SAVE The object SAVE is not present in the scope named XMLDOC Is there any way round this? Grateful for any help 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamically filling a calendar
There is a sample calendar that Figleaf demonstrated at the September CFUG using Flash 5 and WDDX. It is at www.figleaf.com/figleafhome/cfug/cfugsep2000.zip dave At 10:24 AM 10/6/00 -0400, you wrote: Hey folks, I have a calendar(as part of a scheduling app) that I need to fill in dynamically. What I am trying to do is to allow the user to select any month in any year and have the table filled out with the correct "month view" layuot. Is there a way to compare the results of the DateFormat() function OR a variable to the position of the table cell (both row and column) so as to determine where the individual dates should be? Any help would be greatly appreciated. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically filling a calendar
this sounds cool - please email me! -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 16:06 To: CF-Talk Subject: Re: dynamically filling a calendar Yes, post it to the list please. I am in desperate need of something that does exactly that :) Todd Ashworth - Original Message - From: "Kevin Queen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 10:38 AM Subject: RE: dynamically filling a calendar | Oo, me too, pleassse :) | | Could you include me in on that colander code (possibly post it to the | list?) | | Kevin Queen | Software Engineer | Synthetic Logic | | | "Ah, I see!", said the blind man to the deaf mute. -Unknown | | | -Original Message- | From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] | Sent: Friday, October 06, 2000 11:36 AM | To: CF-Talk | Subject: Re: dynamically filling a calendar | | | Jon, | | I just finished writing an article for CFDJ on this very thing. I would be | more than willing to send you the code that generates the calendar as well | as populates it from a Database of events. | | Kevin | - Original Message - | From: "Jon Tillman" [EMAIL PROTECTED] | To: "CF-Talk" [EMAIL PROTECTED] | Sent: Friday, October 06, 2000 9:24 AM | Subject: dynamically filling a calendar | | | Hey folks, | I have a calendar(as part of a scheduling app) that I need to fill in | dynamically. | What I am trying to do is to allow the user to select any month in any | year and | have the table filled out with the correct "month view" layuot. | Is there a way to compare the results of the DateFormat() function OR a | variable to the position of the table cell (both row and column) so as to | determine where the individual dates should be? | | Any help would be greatly appreciated. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle Cold Fusion $1 million dollars
Can anybody comment on MySQL speeds compared to SQL Server and Oracle? You can't really compare this products. MySql is very fast but at a cost of functionality and flexiblity. It has not stored Procedure or SubQuery support. Justin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle Cold Fusion $1 million dollars
I haven't seen the SuSE version, but I have seen Red Hat optimised for Oracle. http://www.redhat.com/products/software/linux/eeoracle/ -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Donovan Rittenbach [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 16:11 To: CF-Talk Subject: RE: Oracle Cold Fusion $1 million dollars First of all, thanks for all the great advice on oracle and cold fusion integration. Secondly, Oracle is THE database company. That is how it got to be the 2nd largest software company in the world(microsoft 1st, veritas 3rd). Oracle 9i, which was showcased at Oracle Openworld here last wednesday, is quite amazing, at least according to the demo. :o) Its performance was so fast in fact, that Larry Ellison said that he'd pay $1 million to anybody who could show a Microsoft database performing anything less than 3X slower than an Oracle database. Plus they are super integrated with Solaris, which is always highly appreciated for those concerned about the enterprise level. Has anybody heard about SuSE's integration with Oracle? They are supposed to be the leading Linux flavor supporting it. Can anybody comment on MySQL speeds compared to SQL Server and Oracle? BTW, on the topic of which, anybody seen Google? Of course. Damn that site is a fast loader and responder!!! Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Calendar Fun
How rude.. I didnt include my snippet! :P !- snip --- CFSET Attributes.dateCurrent = DateAdd("m", 3, Now()) TABLE WIDTH="50%" ALIGN="center" CFSET dateFirstDay = CreateDateTime(Year(Attributes.dateCurrent), Month(Attributes.dateCurrent), 1, 0, 0, 0) CFSET dateLastDay = CreateDateTime(Year(Attributes.dateCurrent), Month(Attributes.dateCurrent), DaysInMonth(Attributes.dateCurrent), 0, 0, 0) CFSET offset = DayofWeek(dateFirstDay) CFSET dateTmp = dateFirstDay CFLOOP FROM="1" TO="#DaysInMonth(Attributes.dateCurrent)#" INDEX="i" CFIF DayOfWeek(dateTmp) EQ 1 OR i EQ 1 TR /CFIF CFIF i EQ 1 CFLOOP FROM="1" TO="#(offset - 1)#" INDEX="j" TD BGCOLOR="#EE" WIDTH="14%" FONT SIZE="2"nbsp;/FONT /TD /CFLOOP /CFIF TD BGCOLOR="#AA" WIDTH="14%" HEIGHT="45" VALIGN="TOP" CFOUTPUTFONT SIZE="1"#i#/FONT/CFOUTPUT /TD CFIF i EQ DaysInMonth(Attributes.dateCurrent) CFSET fillIn = DayOfWeek(7 - dateTmp) CFLOOP FROM="1" TO="#fillIn#" INDEX="k" TD BGCOLOR="#EE" WIDTH="14%" FONT SIZE="2"nbsp;/FONT /TD /CFLOOP /CFIF CFIF DayOfWeek(dateTmp) EQ 7 /TR /CFIF CFSET dateTmp = DateAdd("d", 1, dateTmp) /CFLOOP /TABLE !- snip --- As proof that this was easy I just wrote all of this in about 10 minutes :) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Going Insane...IIF (answer)
OK OK found it..needed a NULL #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE('NULL'))# From: "j p" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Going Insane...IIF Date: Fri, 06 Oct 2000 10:24:28 CDT Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfelse''/cfif ERROR- An error occurred while evaluating the expression: #IIF(Len(conv_data.BankingSpecificLoansDeposits),conv_data.BankingSpecificLoansDeposits,DE(''))# Error near line 428, column 6. An error has occurred while processing the expression: The reason for the error is unknown. The error occurred while processing an _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Script
what is a good referance to learn CF_Script? What URL's do you have? i would like to know why you would or would not use it. what are its benifits? It doesn't really have any benefits. It's an alternative, and an incomplete one at that, to using the CFML tag-based syntax. It might be marginally faster doing some operations, such as initializing lots of variables at once, and it might be slower doing other operations. If you feel more comfortable using it, go ahead and use it. i have noticed that Ultra_Dev uses it alot in its pages. There's a reason UltraDev uses it. UltraDev supports three script environments: CF, ASP and JSP. For doing things like looping over a query, ASP and JSP have similar syntax. In CF, the best way to emulate that syntax is using CFSCRIPT. It's actually less efficient to loop over a query using CFSCRIPT, but it's a lot easier for the Macromedia guys to write code that will work the same way in all three script environments. In general, code generators aren't especially good at producing optimized code. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Going Insane...IIF
Actually.. #IIF(Len(conv_data.BankingSpecificLoansDeposits), DE(conv_data.BankingSpecificLoansDeposits), DE("''"))# Or something like that. ;) Really cfif is alot better. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Going Insane...IIF
No. cfif is more efficient, and you need the DE()'s to produce reasonable results for anything. #IIF(Len(conv_data.BankingSpecificLoansDeposits), DE(conv_data.BankingSpecificLoansDeposits), DE(''))# I think that's right. But then I've been up since this time yesterday. But I know that cfif is faster. ;) Ed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Going Insane...IIF
Try #IIF(Len(conv_data.BankingSpecificLoansDeposits), 'conv_data.BankingSpecificLoansDeposits', DE(''))# (single quotes around "true" epression) -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:24 AM To: CF-Talk Subject: Going Insane...IIF Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfels e''/cfif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call an .EXE from web page
Any leads on an Applet or Active X to do this - it is "planned" to be one of the big hits of our implimentation. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 10:24 AM To: CF-Talk Subject: Re: How to call an .EXE from web page Oh Sorry ! No you can oly do this using a Java Applet or ActiveX control Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:53 PM Subject: RE: How to call an .EXE from web page Doesn't CFExecute execute a on the server? And, it looks like the others do as well (but, Intra tools looks to have great products). I need to run a VB app on the end user's machine. (Like CF C:\Windows\ Calc.exe) -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:20 AM To: CF-Talk Subject: Re: How to call an .EXE from web page cfexecute in CF4 + otherwise look at www.intrafoundation.com for cfx_consolecommand , cfx_spawn etc... Justin - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 3:11 PM Subject: OT: How to call an .EXE from web page Has anyone called a Win .EXE file from a html page? On our intranet, we want to recreate a VB navigational menu system that calls other VB applications (the VB applications reside on a drive that has been mapped on our end users computers). How can I do this? Paul Sizemore -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle Cold Fusion $1 million dollars
Sybase can be twice as fast as Oracle. Which is perhaps why he challenged Microsoft instead. Sybase doesn't need any middleware, and it runs great with CF. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Donovan Rittenbach [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:11 AM To: CF-Talk Subject: RE: Oracle Cold Fusion $1 million dollars Its performance was so fast in fact, that Larry Ellison said that he'd pay $1 million to anybody who could show a Microsoft database performing anything less than 3X slower than an Oracle database. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Going Insane...IIF
IIF is less efficient than CFIF. Look here for a good rundown (http://www.fusionauthority.com/iif.htm). Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfels e''/cfif ERROR- An error occurred while evaluating the expression: #IIF(Len(conv_data.BankingSpecificLoansDeposits),conv_data.BankingSpecificLo ansDeposits,DE(''))# Error near line 428, column 6. -- -- An error has occurred while processing the expression: The reason for the error is unknown. The error occurred while processing an _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OK, Here is the code
This is a multi-part message in MIME format. --=_NextPart_000_0183_01C02F90.1397B780 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I got more requests for the code than I thought I would so here it is. = I didn't include the addupdateevent template or the eventdetail = template. As always if you have any recommendations once you see the = code let me know. Thanks, Kevin !--- Check to see if a specific date was requested or show today --- CFIF IsDefined("form.showdate") CFSET DATETODISPLAY =3D #url.showdate# CFELSE CFSET DATETODISPLAY =3D #DateFormat(Now(), "mm/dd/")# /CFIF !--- Set up the first day of the month requested --- CFSET FIRSTDAY =3D "#DateFormat(DATETODISPLAY, = 'mm')#/01/#DateFormat(DATETODISPLAY, '')#" !--- Set what day the first day of the month is on --- CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "SUN" CFSET LOOPSTART =3D 6 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "MON" CFSET LOOPSTART =3D 0 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "TUE" CFSET LOOPSTART =3D 1 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "WED" CFSET LOOPSTART =3D 2 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "THU" CFSET LOOPSTART =3D 3 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "FRI" CFSET LOOPSTART =3D 4 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "SAT" CFSET LOOPSTART =3D 5 /CFIF CFSET DateCount =3D 1 CFSET DATETOADD =3D DaysInMonth(DATETODISPLAY) - 1 CFSET ODBCLASTDAY =3D #CreateODBCDate(#DateAdd('d', DATETOADD, = FIRSTDAY)#)# CFSET ODBCFIRSTDAY =3D #CreateODBCDate(FIRSTDAY)# CFQUERY DATASOURCE=3D"EventInfo" NAME=3D"Events" SELECT * FROM Events WHERE EventDate=20 BETWEEN #ODBCFIRSTDAY# AND #ODBCLASTDAY# /CFQUERY !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleEvents Calendar/title /head body TABLE WIDTH=3D"525" BORDER=3D"2" CELLSPACING=3D"0" CELLPADDING=3D"4" = BORDERCOLOR=3D"BLACK" TR BGCOLOR=3D"NAVY"=20 =20 TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Monday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Tuesday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Wednesday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Thursday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Friday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Saturday/FONT/TD TD ALIGN=3DCENTER WIDTH=3D"75"FONT FACE=3D"Arial, Helvetica" = SIZE=3D"1" COLOR=3D"#FF"Sunday/FONT/TD /TR =20 TR CFIF LOOPSTART NEQ 0 CFLOOP FROM=3D"1" TO=3D"#LOOPSTART#" INDEX=3D"firstweek" TD ALIGN=3D"center" WIDTH=3D"75" HEIGHT=3D"75"nbsp;/TD /CFLOOP /CFIF =20 CFSET WEEK1 =3D 7 - LOOPSTART CFLOOP FROM=3D"1" TO=3D"#week1#" INDEX=3D"Loop2" CFOUTPUT TD ALIGN=3D"RIGHT" VALIGN=3D"TOP" WIDTH=3D"75" HEIGHT=3D"75"CFIF = (Month(DATETODISPLAY)) EQ (#Month(Now())#) AND (#DateCount# EQ = (#Day(Now())#)) BGCOLOR=3D"NAVY"CFELSEBGCOLOR=3D"##FF"/CFIFFONT = FACE=3D"Arial, Helvetica" size=3D1 /CFOUTPUT CFOUTPUT#DateCount#BR/CFOUTPUT CFOUTPUT QUERY=3D"Events" CFIF (DatePart("d", EventDate) EQ DateCount) A = HREF=3D"eventdetail.cfm?EventID=3D#EventID#"#EventTitle#/ABRBR /CFIF /CFOUTPUT=20 CFSET DateCount =3D DateCount + 1 /TD /CFLOOP =20 /TR CFSET WeekIndex =3D 0 CFSET LOOPTO =3D DaysInMonth(DATETODISPLAY) - 1 CFLOOP FROM=3D"#week1#" TO=3D"#loopto#" INDEX=3D"Loop3" CFIF WeekIndex EQ 0TR/CFIF CFOUTPUT TD ALIGN=3D"RIGHT" VALIGN=3D"TOP" WIDTH=3D"75" HEIGHT=3D"75" CFIF (Month(DATETODISPLAY)) EQ (#Month(Now())#) AND (#DateCount# EQ = (#Day(Now())#)) BGCOLOR=3D"NAVY"CFELSEBGCOLOR=3D"##FF"/CFIFFONT = FACE=3D"Arial, Helvetica" SIZE=3D"1" /CFOUTPUT CFOUTPUT#DateCount#BR/CFOUTPUT CFOUTPUT QUERY=3D"Events" CFIF (DatePart("d", EventDate) EQ DateCount) A = HREF=3D"eventdetail.cfm?EventID=3D#EventID#"#EventTitle#/ABRBR /CFIF /CFOUTPUT=20 /TD CFSET WeekIndex =3D WeekIndex + 1CFSET DateCount =3D DateCount + 1 CFIF WeekIndex EQ 7/TRCFSET WeekIndex =3D 0/CFIF /CFLOOP =20 CFIF WeekIndex NEQ 0 CFLOOP FROM=3D"#WeekIndex#" TO=3D"6" INDEX=3D"Loop4" TD ALIGN=3D"center" WIDTH=3D"75" HEIGHT=3D"75"nbsp;/TD /CFLOOP /CFIF /TR /TABLE BR CENTERA HREF=3D"addupdateevent.cfm?add=3Dyes"Add an event/A /CENTER /body /html Kevin Schmidt Internet Services Director PWB Integrated Marketing and Communications Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_0183_01C02F90.1397B780 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type
Looking for a VTM Script
Once upon a time I stumbled accros a VTM script one of those things that you install in the correct place inside of studio and you can access it as a toolbutton . This VTM script would shuffle the Local Files Folder so it displayed the directory of the current file. This became very useful for me... now I could hit a button and automatically have my CFStudio File System display the current location of my file, and then I could create new documents here. Does anybody have this VTM Script? Know of a location (precise urls?) of VTM repositories? I can find Custom Tags all over the place and even some custom tag editors and such... but nowhere can I find this lovely add-in again. -Patti -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: A list of known security holes?
I thought +htr was an ASP security bug only? At 11:30 AM 10/6/00 -0400, Nadir Ait-Laoussine wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/plain; charset="iso-8859-1" Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir --_=_NextPart_001_01C02FAA.59D650C2-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Server security
on 10/6/00 8:25 AM, Mark W. Breneman at [EMAIL PROTECTED] wrote: IMO: putting the username and password in every CFQUERY tag is asking for trouble. Ok Mark. Where is the best place to put the username and password? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: killing session when browser closes.
I did a little application using session variables. I did a signout page that killed the session, but I also wanted some code that killed the session if the browser was closed. I got this from Forta's book: cflock timeout="20" throwontimeout="No" name="#session.sessionID#" type="exclusive" cfcookie name="CFID" value="#session.CFID#" cfcookie name="CFTOKEN" value="#session.CFTOKEN#" /cflock This code worked fine, and killed the session when I killed the browser. However, I changed the design and moved everything into a POP-UP window. Now when I close the pop-window the session is not killed unless i close the window that spawned the pop-up window. I found this very strange seeing that the page/code that spawned the window was outside the application.cfm code. Is it possible to kill the session when i close the pop-up window? Browsers spawned from the same window, such as popup windows, share the same cookies as the browser from which they're spawned, and vice-versa. So, you can't simply close the popup window and have the cookies disappear. What you should be able to do is to have a JavaScript onunload event for your body tag within the popup window call a page on the server which explicitly deletes the cookies, as well as have JavaScript delete them client-side. Of course, if the user simply clicks the close button, you might be out of luck. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A little off topic but I need help?
Does the ability to install a Win98 partition and a Win2K partition come with Win2K or do we need a third-party utility to do that? You can simply install Win2K to a logical partition within an extended partition, without getting any extra utilities. I think that if you want to set up multiple primary partitions, so that one OS can't directly see the other, which is my personal preference, you'll need something like Partition Magic to create the multiple primary partitions. ... You'll need to use what W2k refers to as a 'Basic' partition and make sure it is formatted as FAT16 or FAT32, not NTFS. Actually, if you keep Win2K (or NT for that matter) on its own partition, you can use NTFS. I've set it up both within a logical partition and within a separate primary partition, using NTFS every time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SiteMinder: Previous Thread
About a week or so ago, there was a small thread talking about a security issue uncovered with Siteminder. Does anyone happen to have links to this info, what it was about, if it has been fixed etc? I can't seem to find any sort of mention on either Allaire, or Netegrity to this. Thanks in advance. Shane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A list of known security holes?
http://www.securityfocus.com/ http://www.beyondsecurity.com/ (*just found) http://www.w3.org/Security/Faq/www-security-faq.html (old info?) Also I have heard of a site something like bugtrack.com that is said to be very good. I have not found it yet. Anyone know the correct name? And read and memorize "Hacking Exposed: Network Security Secrets and Solutions" http://www.amazon.com/exec/obidos/ASIN/0072121270/ More of a how to / how to protect yourself book. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 10:30 AM To: CF-Talk Cc: James Dunham Subject: A list of known security holes? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/plain; charset="iso-8859-1" Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVSPAN class=781032715-06102000FONT face=Arial size=2Hello all;/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2I recently came across the .+htr hole and am wondering about any other things that should be looked at./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Thanks/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Nadir/FONT/SPAN/DIV/BODY/HTML --_=_NextPart_001_01C02FAA.59D650C2-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Form's fields as URL parameter too...
In your Form or CFForm tag, you get to chosse the METHOD. The default (strangely) is GET, which passes the form fields appended to the URL. If you use POST for the METHOD, the fields will be passed via the HTTP headers, which is usually preferable IMHO. I'm being slightly and probably unnecessarily anal here, but actually when you POST data, the data is passed back to the server in the HTTP request body, not the HTTP request headers. When you send a GET request with URL parameters, that data is in the very first line of the HTTP request headers. On this very topic, there's a pretty neat new O'Reilly mini-book, almost a pamphlet, which covers the HTTP protocol. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
combining text fields in a query
Before upgrading MDAC, I used to be able to combine text fields in a query. I was doing this to pack more information into the Custom fields in Verity. EG: This Access 97 query used to work... SELECT (articles.title + articles.subtitle) AS CombinedTitle Since the MDAC upgrade I get an error when I use that syntax (also when using '' rather than '+'): CMemoryException: unknown cause - PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Is this just a syntax issue with the new MDAC (if so, can anyone tell me the proper syntax?) or am I no longer allowed to do this? The error occurrs under both MDAC 2.5 and 2.6. The MDAC version I was using previously (when it worked) was the one that shipped with CF 3. Now running CF 4.0.1, NT4 SP6a, MDAC 2.6, if that matters. Any suggestions would be appreciated! Thanks, Darin Cosgrove -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion and WAP!!!!!
Been there, done that. The problem is that the simulator does not like the extension .cfm. What I did is configure my web server (IIS on Win2K) to pass wml to coldfusion. and then I write all with extension .wml. Even if there is no CFML code, it will go thru cold fusion and work OK. They way I did that was Open Internet Services Manager Click on your default web site Right click and open "properties" Go to the "Home Directory" tab Click on configuration Note the setting for .cfm and duplicate that for .wml And be ready to start dealing with other problems... Jaime/ -Original Message- From: Suhail Khaki [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 11:57 PM To: CF-Talk Subject: ColdFusion and WAP! hi.. I am trying to use coldfusion with wml using jataayu gateway on linux. My cf code is as follows.. ## cfcontent type="text/vnd.wap.wml" ?xml version="1.0"? !DOCTYPE wml PUBLIC "-//PHONE.COM//DTD WML 1.1//EN" "http://www.phone.com/dtd/wml11.dtd" wml card id="card1" title="cf-card" p hello how r u? /p /card /wml ## I am saving it as cfwml.cfm and trying to access it from a nokia simmmulator but unsuccessfully. But i am able to access the files with .wml extension in the same folder from nokia simmulator.As soon as i request the .cfm file from the simmulator , the gateway crashes... Is there any problem with my code? or do we need to configure the cfserver? or can it be the problem with the gateway? PLz try to help.. thanking suhail __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A list of known security holes?
A good place to start is: http://www.allaire.com/developer/securityzone/ Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 Find a Job in San Antoniohttp://www.sajobnet.com -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 10:30 AM To: CF-Talk Cc: James Dunham Subject: A list of known security holes? Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A list of known security holes?
shameless plug for our fearless list host - Mike D's Site House of Fusion (www.houseoffusion.com) has an excellent security section. /shameless plug Shawnea -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:30 AM To: CF-Talk Cc: James Dunham Subject: A list of known security holes? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/plain; charset="iso-8859-1" Hello all; Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases. I recently came across the .+htr hole and am wondering about any other things that should be looked at. Thanks Nadir --_=_NextPart_001_01C02FAA.59D650C2 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVSPAN class=781032715-06102000FONT face=Arial size=2Hello all;/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Does anyone know of a good web site that lists the security holes with all the major web servers / CF server / Databases./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2I recently came across the .+htr hole and am wondering about any other things that should be looked at./FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Thanks/FONT/SPAN/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=781032715-06102000FONT face=Arial size=2Nadir/FONT/SPAN/DIV/BODY/HTML --_=_NextPart_001_01C02FAA.59D650C2-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OK, Here is the code
It looks like you went over the same thing I did to set up the offsets for the first week. Instead of doing the 7 comparisons to figure out the day of the week you can just use DayOfWeek which basically does it for you (See my previous post :) I was going to do the same thing and then i figured out DayOfWeek function does that a ton easier. So using DayOfWeek trims the number of comparisons as well :) My snippet also displays how to use the DayOfWeek function to fill in your last few columns as well. Jeremy Allen [EMAIL PROTECTED] -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 1:22 PM To: CF-Talk Subject: OK, Here is the code This is a multi-part message in MIME format. --=_NextPart_000_0183_01C02F90.1397B780 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I got more requests for the code than I thought I would so here it is. = I didn't include the addupdateevent template or the eventdetail = template. As always if you have any recommendations once you see the = code let me know. Thanks, Kevin !--- Check to see if a specific date was requested or show today --- CFIF IsDefined("form.showdate") CFSET DATETODISPLAY =3D #url.showdate# CFELSE CFSET DATETODISPLAY =3D #DateFormat(Now(), "mm/dd/")# /CFIF !--- Set up the first day of the month requested --- CFSET FIRSTDAY =3D "#DateFormat(DATETODISPLAY, = 'mm')#/01/#DateFormat(DATETODISPLAY, '')#" !--- Set what day the first day of the month is on --- CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "SUN" CFSET LOOPSTART =3D 6 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "MON" CFSET LOOPSTART =3D 0 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "TUE" CFSET LOOPSTART =3D 1 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "WED" CFSET LOOPSTART =3D 2 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "THU" CFSET LOOPSTART =3D 3 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "FRI" CFSET LOOPSTART =3D 4 /CFIF CFIF #DateFormat(FIRSTDAY, 'DDD')# EQ "SAT" CFSET LOOPSTART =3D 5 /CFIF -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query assignment... copy or reference?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 To the best of my memory, it's by reference. And I'll second your comment about the CFDOCs. It would be nice if they'd document whether things were byref or bycopy rather than leaving it up to the programmer to guess... Best regards, Zac Bedell -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 12:51 PM To: CF-Talk Subject: Query assignment... copy or reference? When I assign a query variable to another query variable, does it make a copy or use a reference (pointer)? Specifically I have the following in a module: I take the name of a query as an argument, and I want to use that query: cfset defquery=evaluate("caller.#attributes.defquery#") Is this making a copy of all the data, or just a reference to the original? (BTW, why is it that none of the CF books discuss queries as a data type? It is a perfectly valid data type to use as you need even if it has nothing to do with a database. It has it's own strengths and weaknesses distinct from structures.) -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOd4HMwraVoMWBwRBEQIazQCgqTHSYuEIiTeKUPnpv3E2iaO0beQAn378 ujDLd6wLharXRa7/TYb6Fzd4 =US20 -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOBJECT Sessions
You could put all of the properties you want into a structure and then copy the structure into the session variable. Have a look at CF_XMLPARSE on http://www.siteobjects.com/index.cfm?fuseAction=showProducts for a really good XML tag that puts a document into a structure. Paul -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 16:32 To: CF-Talk Subject: CFOBJECT Sessions I'm using a COM object to parse an XML doc: cfobject action="CREATE" class="Microsoft.XMLDom" type="COM" name="xmlDoc" That works fine as long as I only have one page. But once I've loaded the document, I want to keep it in memory across pages. I put it in a session variable: Session.xmlDoc = xmlDoc; and in the next page, when I do cfif isDefined("Session.xmlDoc") EQ "true" I get the right answer. BUT, I can't access any of the object's properties. Error resolving parameter XMLDOC.SAVE The object SAVE is not present in the scope named XMLDOC Is there any way round this? Grateful for any help 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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A list of known security holes?
I thought +htr was an ASP security bug only? It's an IIS problem, so if you're running CF on IIS, and haven't followed IIS security best practices, you may be vulnerable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: A list of known security holes?
It's actually an IIS security bug and will show the source of a CFM file as well. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Cc: "James Dunham" [EMAIL PROTECTED] Sent: Friday, October 06, 2000 12:39 PM Subject: Re: A list of known security holes? I thought +htr was an ASP security bug only? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call an .EXE from web page
Any leads on an Applet or Active X to do this - it is "planned" to be one of the big hits of our implimentation. Yea, well don't "plan" on me or many other security conscious folks let it run if you do get it done. :) Anyway, as was said, the only way to do this on a non-intranet user's machine "automatically" is basically through an windows activex, a plugin or java. They could as well download a setup.exe to install a small client app that runs in the background. What route you go depends what it is and what platforms you want to support. --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Structure Output Loop
This is a multi-part message in MIME format. --=_NextPart_000_0005_01C03062.07F37D60 Content-Type: multipart/alternative; boundary="=_NextPart_001_0006_01C03062.07F37D60" --=_NextPart_001_0006_01C03062.07F37D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Is there any way to quickly output all elements of a structure as a loop? Joshua Miller Web Development Eagle Technologies Group, Inc. Business Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] --=_NextPart_001_0006_01C03062.07F37D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D430402217-07102000Is = there any way to=20 quickly output all elements of a structure as a = loop?/SPAN/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Joshua MillerBRWeb = Development/FONT/DIV DIVFONT face=3DArial size=3D2Eagle Technologies Group, = Inc./FONT/DIV DIVFONT face=3DArial size=3D2Business Solutions for the Next=20 Generation/FONT/DIV DIVFONT face=3DArial size=3D2A=20 href=3D"http://www.eagletgi.com/"www.eagletgi.com/A/FONT/DIV DIVFONT face=3DArial size=3D2A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FO= NT/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_001_0006_01C03062.07F37D60-- --=_NextPart_000_0005_01C03062.07F37D60 Content-Type: text/x-vcard; name="Joshua Miller.vcf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Joshua Miller.vcf" BEGIN:VCARD VERSION:2.1 N:Miller;Joshua FN:Joshua Miller ORG:Eagle Technologies Group, Inc.;Web Development TITLE:Web Developer NOTE;ENCODING=3DQUOTED-PRINTABLE:Joshua Miller=3D0D=3D0AWeb Site = Development=3D0D=3D0AEagle Technologies Group, Inc.=3D =3D0D=3D0ABusiness Solutions for the Next = Generation=3D0D=3D0Ahttp://www.eagletgi.co=3D [EMAIL PROTECTED]=3D0D=3D0A=3D0D=3D0A =3D0D=3D0A=20 TEL;WORK;VOICE:(304) 456-4942 TEL;HOME;VOICE:(304) 456-4942 ADR;WORK:;Clarksburg, WV;HC 63 Box 52c;Arbovale;WV;24915;United States = of America LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Clarksburg, WV=3D0D=3D0AHC 63 Box = 52c=3D0D=3D0AArbovale, WV 24915=3D0D=3D0AUnited States=3D of America URL: URL:http://www.eagletgi.com ROLE:Web Application Developer BDAY:2826 EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20001005T135238Z END:VCARD --=_NextPart_000_0005_01C03062.07F37D60-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.