Re: OLE DB for SQL Server

2000-10-06 Thread Mooner Ent
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

accessing a query as an array

2000-10-06 Thread Jon Hall
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

re: accessing a query as an array...reformatted

2000-10-06 Thread Jon Hall
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

ColdFusion and WAP!!!!!

2000-10-06 Thread Suhail Khaki
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"

Re: accessing a query as an array

2000-10-06 Thread Jim McAtee
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

Re: Random Record: methods

2000-10-06 Thread pan
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"

Re: accessing a query as an array

2000-10-06 Thread Jon Hall
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,

Re: ColdFusion SP2

2000-10-06 Thread Aidan Whitehall
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

RE: Error creating Verity collection

2000-10-06 Thread Richard Brotherton A/Prog CP
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

RE: Random Record

2000-10-06 Thread Juan Andres Alvarez Valenzuela
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 -

Parsing, and assigning variables.

2000-10-06 Thread Brian bouldernet
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

RE: ColdFusion SP2

2000-10-06 Thread Rich Wild
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

Re: IBM, Allaire Singled Out For Annual Report Card Honors

2000-10-06 Thread Adrian Cooper
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

Kinda OT : Java based file uploader

2000-10-06 Thread James Sleeman
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

Re: Studio vs. HomeSite

2000-10-06 Thread Dave Hannum
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

SQL Server security

2000-10-06 Thread Aidan Whitehall
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

Re: Random Record

2000-10-06 Thread pan
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

Re: Realsim and 4D Arrays

2000-10-06 Thread Wjreichard
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:

Re: Parsing, and assigning variables.

2000-10-06 Thread pan
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

SQL Server Decimal

2000-10-06 Thread Paul Johnston
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 (

RE: SQL Server Decimal

2000-10-06 Thread Andy Ewings
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.

RE: SQL Server Decimal

2000-10-06 Thread Paul Johnston
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.

RE: Realsim and 4D Arrays

2000-10-06 Thread Paul Ihrig
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

RE: SQL Server Decimal

2000-10-06 Thread Andy Ewings
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

RE: SQL Server Decimal

2000-10-06 Thread Paul Johnston
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

RE: SQL Server Decimal

2000-10-06 Thread Andy Ewings
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

CF Script

2000-10-06 Thread Paul Ihrig
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

RE: SQL Server Decimal

2000-10-06 Thread Paul Johnston
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

Fw: CF Script

2000-10-06 Thread JustinMacCarthy
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

RE: CF Script

2000-10-06 Thread Simon Horwith
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

OT: Once In A Lifetime Photo

2000-10-06 Thread Dave Hannum
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

RE: SQL Server security

2000-10-06 Thread Mark W. Breneman
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

RE: Random Record

2000-10-06 Thread Larry Juncker
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

RE: Random Record

2000-10-06 Thread Larry Juncker
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

Creating graph objects

2000-10-06 Thread Denis POUMEYRAU
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:

RE: verisign payflow link?

2000-10-06 Thread Paul Sizemore
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

RE: Once In A Lifetime Photo

2000-10-06 Thread Paul Ihrig
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

RE: Random Record

2000-10-06 Thread Juan Andres Alvarez Valenzuela
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

Re: How to call an .EXE from web page

2000-10-06 Thread JustinMacCarthy
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

dynamically filling a calendar

2000-10-06 Thread Jon Tillman
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()

Re: OT: Once In A Lifetime Photo

2000-10-06 Thread Peter Theobald
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"

RE: Kinda OT : Java based file uploader

2000-10-06 Thread Zachary Bedell
-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

Realsim and 4D Arrays

2000-10-06 Thread Gavin Myers
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,

Re: dynamically filling a calendar

2000-10-06 Thread Kevin Schmidt
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

RE: dynamically filling a calendar

2000-10-06 Thread Kevin Queen
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

RE: dynamically filling a calendar

2000-10-06 Thread Jones, Matt
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

Re: dynamically filling a calendar

2000-10-06 Thread Jon Tillman
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

Re: dynamically filling a calendar

2000-10-06 Thread Jason Stiefel
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

Re: dynamically filling a calendar

2000-10-06 Thread Todd Ashworth
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 |

RE: SQL Server security

2000-10-06 Thread Aidan Whitehall
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

RE: How to call an .EXE from web page

2000-10-06 Thread Paul Sizemore
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]]

RE: Realsim and 4D Arrays

2000-10-06 Thread Paul Ihrig
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

RE: Kinda OT : Java based file uploader

2000-10-06 Thread Ed Toon
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

RE: SQL question

2000-10-06 Thread Hayes, David
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:

Re: dynamically filling a calendar

2000-10-06 Thread Kevin Schmidt
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

RE: dynamically filling a calendar

2000-10-06 Thread Ed Toon
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

RE: dynamically filling a calendar

2000-10-06 Thread Moneymaker, Jon S (WPNSTA Yorktown)
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

RE: dynamically filling a calendar

2000-10-06 Thread Larry Juncker
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

RE: Oracle Cold Fusion $1 million dollars

2000-10-06 Thread Donovan Rittenbach
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

RE: dynamically filling a calendar

2000-10-06 Thread Jeremy Allen
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

Re: How to call an .EXE from web page

2000-10-06 Thread JustinMacCarthy
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

WAP, Cold Fusion and Palm Pilot OS Development

2000-10-06 Thread Donovan Rittenbach
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] --

Going Insane...IIF

2000-10-06 Thread j p
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

Re: dynamically filling a calendar

2000-10-06 Thread Winston Hardson
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

A list of known security holes?

2000-10-06 Thread Nadir Ait-Laoussine
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

Re: dynamically filling a calendar

2000-10-06 Thread tom muck
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

CFOBJECT Sessions

2000-10-06 Thread DeVoil, Nick
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:

Re: dynamically filling a calendar

2000-10-06 Thread dave fauth
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.

RE: dynamically filling a calendar

2000-10-06 Thread Gavin Lilley
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,

Re: Oracle Cold Fusion $1 million dollars

2000-10-06 Thread JustinMacCarthy
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

RE: Oracle Cold Fusion $1 million dollars

2000-10-06 Thread Gavin Lilley
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

Calendar Fun

2000-10-06 Thread Jeremy Allen
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 =

Re: Going Insane...IIF (answer)

2000-10-06 Thread j p
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

RE: CF Script

2000-10-06 Thread Dave Watts
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

RE: Going Insane...IIF

2000-10-06 Thread Ed Toon
Actually.. #IIF(Len(conv_data.BankingSpecificLoansDeposits), DE(conv_data.BankingSpecificLoansDeposits), DE("''"))# Or something like that. ;) Really cfif is alot better. -- Archives:

RE: Going Insane...IIF

2000-10-06 Thread Ed Toon
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

RE: Going Insane...IIF

2000-10-06 Thread mherbene
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

RE: How to call an .EXE from web page

2000-10-06 Thread Paul Sizemore
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

RE: Oracle Cold Fusion $1 million dollars

2000-10-06 Thread Lon Lentz
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!

Re: Going Insane...IIF

2000-10-06 Thread Michael Dinowitz
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),

OK, Here is the code

2000-10-06 Thread Kevin Schmidt
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

Looking for a VTM Script

2000-10-06 Thread Patricia Lee
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

Re: A list of known security holes?

2000-10-06 Thread Peter Theobald
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:

Re: SQL Server security

2000-10-06 Thread sebastian palmigiani
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

RE: killing session when browser closes.

2000-10-06 Thread Dave Watts
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#"

RE: A little off topic but I need help?

2000-10-06 Thread Dave Watts
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

SiteMinder: Previous Thread

2000-10-06 Thread Shane Pitts
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

RE: A list of known security holes?

2000-10-06 Thread Mark W. Breneman
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

RE: Getting Form's fields as URL parameter too...

2000-10-06 Thread Dave Watts
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

combining text fields in a query

2000-10-06 Thread Darin Cosgrove
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

RE: ColdFusion and WAP!!!!!

2000-10-06 Thread Jaime Garza
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

RE: A list of known security holes?

2000-10-06 Thread Chris Montgomery
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

RE: A list of known security holes?

2000-10-06 Thread Shawnea Carter
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

RE: OK, Here is the code

2000-10-06 Thread Jeremy Allen
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

RE: Query assignment... copy or reference?

2000-10-06 Thread Zachary Bedell
-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

RE: CFOBJECT Sessions

2000-10-06 Thread Paul Johnston
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

RE: A list of known security holes?

2000-10-06 Thread Dave Watts
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

Re: A list of known security holes?

2000-10-06 Thread Howie Hamlin
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

RE: How to call an .EXE from web page

2000-10-06 Thread lsellers
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

Structure Output Loop

2000-10-06 Thread Joshua Miller
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"

  1   2   >