RE: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Taco Fleur
Work with the session scope, as soon as a page is submitted you append the FORM structure to a structure stored in the session, I have a CFC that does the trick if your interested. So basically upon each submit you append the all form values to a structure in the session scope, at the end you

RE: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Taco Fleur
It would be better written like !--- Create hidden form fields for the Form scope --- cfoutput cfloop collection=#form# item=field input type=hidden name=#variables.field# value=#form[variables.field]# /cfloop /cfoutput Taco Fleur Bloghttp://www.tacofleur.com/index/blog/

RE: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Taco Fleur
I had to take few bits out that were specific to my app. I hope it still runs as it should. You should probably name contactNew structure more specific to your app. The structDelete(contactNew.form, BTNSUBMIT); stuff is just so I don't save buttons in the structure Its as simple as calling the

Java Files

2004-01-29 Thread Shahzad.Butt
I've installed CFMX6.1 on Websphere. When I run a file say test.cfm it generates a java class which is cftest2ecf9184 Which is fine what I need more is to get the .java file for the same class. Just not familiar with the architecture does CFMX create java files and then compiles it to class

RE: Java Files

2004-01-29 Thread Tim Blair
does CFMX create java files The original MX did, but 6.1 doesn't - the compiler does a direct CF code - java byte code (.class file) compilation to save (lots and lots of) time during the compilation and initial run phase.Doesn't make a huge difference in production but sure makes development

Mail Transaction Failed

2004-01-29 Thread jochemd
„laTE Ssµ|¦TŒmSI¾—#¢bL} i-…¶0©¢¼”º ÐTB.¯kµ²œkoŽI7 1.–UŸv¾2,«sŸaK°qaj˜U2¤¿G§qg¨bªd™yN‘GPD2½k_’¡L¡™kŒN7«m†jš’У½’¥¶‹Ooµf±–Y!2[®RYy ÷Q‹X-›\‚\(¦¹u]B³z#!, HI•µlS¯›•ˆ£§c{4*^U²n–¦wµ™:O4^ˆ²BŽ„y-¤B[WNaa”gJ•¡dG7°rºY5MC²)w²'?L»÷˜º/‰÷S‚”Mu3…|\­#n± †l‘9e¿´‰ Ice¶i§¼Š„\£°›MS–QI¶“W× qŠZ)‚2¤±Pi 

OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Yves Arsenault
Hey, This really looks like a ColdFusion clone. www.steelarrow.com Check out the code examples SAIF COND=IsDefined(Var) SAOUTPUT #Var# /SAOUTPUT SAELSE Sorry... /SAIF Look familliar?? - Yves - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Yves Arsenault
Hey, This really looks like a ColdFusion clone. www.steelarrow.com Check out the code examples SAIF COND=IsDefined(Var) SAOUTPUT #Var# /SAOUTPUT SAELSE Sorry... /SAIF Look familliar?? - Yves - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Anyone ever see this?? SteelArrow?

2004-01-29 Thread Josh Remus
that's a little scary, really. -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 8:33 AM To: CF-Talk Subject: OT:Anyone ever see this?? SteelArrow? Hey, This really looks like a ColdFusion clone. www.steelarrow.com Check out the code

RE: Partitioning Custom Tags for multiple code lines?

2004-01-29 Thread Gaulin, Mark
Hi That's an interesting way to look at it... like a java import statement. (In fact, *very much* like a java import statement). I like it.Now I just have to wait for us to roll out cfmx in production... Thanks Mark -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]

On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Candace Cottrell
Hey folks, I am officially stumped. I am still working on this on-call calendar. Here's what I am trying to accomplish: If the day (number) is the first day of the shift and the shift start hour is not equal to 8, then I'd like to output ON: 7AM under the doctor's name. Likewise, if

Re: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Pete Ruckelshaus
Looks interesting, but at $750 I think I'll stick with a more widely accepted technology :-) Pete Yves Arsenault wrote: Hey, This really looks like a ColdFusion clone. www.steelarrow.com Check out the code examples SAIF COND=IsDefined(Var) SAOUTPUT #Var# /SAOUTPUT SAELSE

Best practises question

2004-01-29 Thread David Adams
In the following snippet, what is better form for representing a true statement in the CFIF (ie. YES, true, or 1)? cfset arr_fruit=ArrayNew(1) cfset arr_fruit[1]=apple cfset arr_fruit[2]=banana cfset arr_fruit[3]=pear cfset edible = ArrayAppend(arr_fruit,pineapple) !--- cfif edible IS YES --- or

RE: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Robertson-Ravo, Neil (RX)
it would seem strange to type anything else other than CF... or CFA_ :-)! _ From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 13:49 To: CF-Talk Subject: Re: OT:Anyone ever see this?? SteelArrow? Looks interesting, but at $750 I think I'll stick with a more

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Jochem van Dieten
Candace Cottrell said: cfloop from=1 to=#rows# index=i tr height=15% cfloop from=1 to=7 index=j td align=left valign=top cfif #page[j][i]# is -1 nbsp; cfelse !-- Outputting the DAY number-- h2cfoutput#page[j][i]#/cfoutput /h2 span class=bodyCopy cfquery name=getByDay

Re: Best practises question

2004-01-29 Thread Jochem van Dieten
David Adams said: In the following snippet, what is better form for representing a true statement in the CFIF (ie. YES, true, or 1)? cfset arr_fruit=ArrayNew(1) cfset arr_fruit[1]=apple cfset arr_fruit[2]=banana cfset arr_fruit[3]=pear cfset edible = ArrayAppend(arr_fruit,pineapple) !---

RE: Best practises question

2004-01-29 Thread Stephen Barry
Hi David As far as I'm aware the best practice in this example is actually: cfif edible More fruit added to arr_fruit cfelse NO fruit added /cfif Regards Steve. -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 12:59 To: CF-Talk Subject: Best

RE: Best practises question

2004-01-29 Thread Hagan, Ryan Mr (Contractor ACI)
I've read several places that it's preferable to use the following syntax: cfif edible cfelse /cfif -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 7:59 AM To: CF-Talk Subject: Best practises question In the following snippet, what

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Candace Cottrell
Ok, it worked so was there a problem with my cfif's? I see that you combined them into one. Jochem, thanks, as always, for your help. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org

RE: Best practises question

2004-01-29 Thread Tony Weeg
or http://www.cflib.org/udf.cfm?ID=968 cfset arr_fruit=ArrayNew(1) cfset arr_fruit[1]=apple cfset arr_fruit[2]=banana cfset arr_fruit[3]=pear cfset edible = ArrayAppend(arr_fruit,pineapple) cfif isDefinedValue(edible) Yes cfelse No /cfif I like this better, since it checks for its presence

RE: cfmx and activePDF Spooler

2004-01-29 Thread Yexley Robert D Contr AFRL/PROE
I don't know about this particular product, but I'm using the ActivePDF Toolkit in my CFMX application, and it works fine.Occasionally I get an error instantiating the COM object, but it was very flaky and intermittent, so I just wrote an exception handler to juts re-run the page to try to execute

RE: Best practises question

2004-01-29 Thread Qasim Rasheed
Can't you just use cfif edible cfelse /cfif Qasim -Ori ginal Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 7:59 AM To: CF-Talk Subject: Best practises question In the following snippet, what is better form for representing a true

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Jochem van Dieten
Candace Cottrell said: Ok, it worked so was there a problem with my cfif's? Apparently ;-) It just seemed easier to replace the QofQ's with simple comparisons. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Best practises question

2004-01-29 Thread Tony Weeg
of course. but as a Best Practice since edible may not *always* be defined or have a value I would consider it a best practice to check for the presence and the value and the slickest way ive seen so far is that udf.that's all. tony -Original Message- From: Qasim Rasheed [mailto:[EMAIL

RE: SQL and displaying date ranges

2004-01-29 Thread Ian Skinner
A tested code example for ORACLE.I think I had my outer join on the wrong side in my previous, off the top of my head example. SELECT DATETEST.DATE_COL, All_DAYS.DAYS, DATETEST.R_MED_EDATE, DATETEST.R_MED_DESC FROM DATETEST, ( SELECT TO_DATE('01/01/2004', 'MM/DD/') - 1 + rownum

RE: cfmx and activePDF Spooler

2004-01-29 Thread Tony Weeg
I will. I have an email into activePDF to see what they recommend. thanks! tony -Original Message- From: Yexley Robert D Contr AFRL/PROE [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 9:35 AM To: CF-Talk Subject: RE: cfmx and activePDF Spooler I don't know about this

Re: Best practises question

2004-01-29 Thread Josh
Not sure what the best practice is... But I have frequently used: cfif edible /cfif Actually, I prefer to use cfscript whenever possible. so it would be: cfscript arr_fruit=ArrayNew(1); arr_fruit[1]=apple; arr_fruit[2]=banana; arr_fruit[3]=pear; edible = ArrayAppend(arr_fruit,pineapple); if

Re: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Christian Cantrell
On Wednesday, January 28, 2004, at 04:28PM, Justin Jefferson wrote: I'm working with a multipage survey (3 pages) and I'm trying to figure out how to pass the survey answers over the multiple pages. I highly recommend using the session scope as others have suggested. That way, users can back

PGP Digital Signed Email

2004-01-29 Thread Robertson-Ravo, Neil (RX)
OK, I know that using PGP and a CFX tag you can digitall sign emails in CF5..but whats required on the client end? Anything? or is it a case of simply tagging the mail and thats it?I would assume some kind of public key will be involved? Also, if we are using this to tag invoices etc, what

RE: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Raymond Camden
I'm a bit late to this - but if you are looking for a packaged solution, I've got a custom tag called PLP (same name as the old spectra feature) that makes it a bit easier to work with N step forms. You can read more about it here:

Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
You know, I just figured something out. This where clause: cfqueryparam cfsqltype=cf_sql_integer value=#page[j][i]#BETWEEN START_DAY AND END_DAY AND cfqueryparam cfsqltype=cf_sql_integer value=#URL.M# BETWEEN START_MONTH AND END_MONTH AND cfqueryparam cfsqltype=cf_sql_integer value=#URL.Y#

Re: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Bryan Stevenson
So just how trustworthy are CF Session vars in a clustered environment these days (as they have a history of getting lost/not sticking)?? I've always wriiten my own custom session handling, but it can get a tad laborious (like in the case of multipage forms).So I figured I'd see if things have

QoQ bug? Help rqd...

2004-01-29 Thread Tim Blair
Can someone else try running this little bit of code please: cfset variables.newQ = querynew(col1) cfset queryaddrow(variables.newQ) cfset querysetcell(variables.newQ, col1, Thu 29 Jan) cfdump var=#variables.newQ# cfquery name=variables.testQoQ dbtype=query SELECT * FROM newQ /cfquery cfdump

Re: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Jochem van Dieten
Candace Cottrell wrote: cfqueryparam cfsqltype=cf_sql_integer value=#page[j][i]# BETWEEN START_DAY AND END_DAY AND cfqueryparam cfsqltype=cf_sql_integer value=#URL.M# BETWEEN START_MONTH AND END_MONTH AND cfqueryparam cfsqltype=cf_sql_integer value=#URL.Y# BETWEEN START_YEAR AND END_YEAR

CFHTTP Help needed

2004-01-29 Thread Eric Creese
The code I originally wrote has morphed into the following with some help from others on the list. However I am getting an error. It seems to not like the attribute variable for the query. One other thing. The URL from Yahoo seems to like the symbols to be separated with a + sign and my code is

RE: SQL and displaying date ranges

2004-01-29 Thread cf-talk
Ian, Thanks for the tip.I'm using MS SQL 2000 so I guess I'll have to do some digging. Does anyone else out there have an MS SQL 2000 example... or another suggestion?It just seems like such a simple every day type of thing to me.I'm surprised there wasn't more feedback on the topic.

Re: How to Pass Varibles on Multipage Form?

2004-01-29 Thread Jamie Jackson
On Thu, 29 Jan 2004 08:12:31 -0800, in cf-talk you wrote: So just how trustworthy are CF Session vars in a clustered environment these days (as they have a history of getting lost/not sticking)?? They're not trustworthy in a clustered environment, but that's not what they're for. *Client*

Calendar query?

2004-01-29 Thread C. Hatton Humphrey
Does anyone know of a way to create a query with a range of dates and any matching records that might match in a database in one query?For example, if I'm looking at a table that has the following: ID | Date | Event ---++--- 1 | 01/01/2004 | New Years Day 2 |

RE: Calendar query?

2004-01-29 Thread Eric Creese
simplistically in SQL SELECT date,event FROM events WHERE date BETWEEN '1/14/2004' AND '2/16/2004' -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 10:33 AM To: CF-Talk Subject: Calendar query? Does anyone know of a way to create a

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Andrew S. Peterson
Hi Ben, I've been contemplating the same thing for an old Access application of mine. My main reason for doing so would be to overcome the great difficulty of distributing an Access app. However, with VB, you don't really have that problem, or do you? In any event, I'm curious as to your

Boring old topic: CF based hit counter / stats

2004-01-29 Thread J M
Hi all, I hate to dig up such a boring topic, but I could not find a great answer in the archives. I have a client who want to know absolutely as much as possible about visits to her site. It needs to be hosted on my server, preferably CF based and uses SQL server as a backend. Cost is not so

RE: Calendar query?

2004-01-29 Thread C. Hatton Humphrey
That would only give me the events in the database between the date range. What I'm wanting is all dates between the range and any matching events in the database.For my example the record set would be something like ID | Date | Event ---++--- 1 | 01/15/2004 | NULL 2

RE: Boring old topic: CF based hit counter / stats

2004-01-29 Thread Eric Creese
I use Statistex. I think I paid $60 bucks and it works GREAT! -Original Message- From: J M [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 9:40 AM To: CF-Talk Subject: Boring old topic: CF based hit counter / stats Hi all, I hate to dig up such a boring topic, but I could not

RE: Anyone ever see this?? SteelArrow?

2004-01-29 Thread Jim Davis
Well - considering that it should be easy to convert to CFML.;^) Anybody remember WebPlus - did the same thing.Nearly perfectly mimicked CF 2.0 then released a CF-to-WebPlus conversion package - then promptly went out of business.;^) Jim Davis _ From: Josh Remus [mailto:[EMAIL

RE: Calendar query?

2004-01-29 Thread Eric Creese
You can do an inner join on the same table then SELECT a.date,b.event FROM events a LEFT OUTER JOIN events b ON a.id = b.id WHERE b.date BETWEEN '1/14/2004' AND '2/16/2004' -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 10:46 AM

RE: Calendar query?

2004-01-29 Thread C. Hatton Humphrey
Sorry, rereading the question I didn't mention the fact that the database only contains records that have events.The recordset I keyed in is what I would like for a result set, not what is in the database. Thanks for the suggestions! Hatton You can do an inner join on the same table then

Re: Boring old topic: CF based hit counter / stats

2004-01-29 Thread Rob Rohan
If you like free http://www.mrunix.net/webalizer/ is a good product I use it quite a bit On Thu, 2004-01-29 at 07:40, J M wrote: Hi all, I hate to dig up such a boring topic, but I could not find a great answer in the archives. I have a client who want to know absolutely as much as possible

RE: CFHTTP Help needed

2004-01-29 Thread Mosh Teitelbaum
Eric: Remove the CFOUTPUT tags from your CFHTTP tag.The CFHTTP code should look like: cfhttp url=""> at=sc1l1ext=.csv method=GET name=qStockItems columns=Symbol,Change,LastTradedPrice textqualifier= delimiter=, firstrowasheaders=no You never use CFOUTPUT inside of an attribute value.If you want

Re: Boring old topic: CF based hit counter / stats

2004-01-29 Thread Doug White
Take a look at WebLog Expert at http://www.weblogexpert.com/ And see a sample of the stats it generates from the log files at http://www.strictlyhodaka.com/report/index.htm For a Linux environment, use the free Webalyzer == Stop spam on your domain, Anti-spam

RE: Anyone ever see this?? SteelArrow?

2004-01-29 Thread Matt Robertson
I remember someone spotting this site a couple of years ago.They were unknown then and seem to have stayed that way. http://www.google.com/search?q=allinurl%3A++%22*+aro%22+filetype%3Aarob tnG=Google+Searchnum=100hl=enlr=ie=UTF-8oe=UTF-8c2coff=1as_qdr=al l

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Shawn Regan
Sorry, Never heard of Coral. What is Coral and where can you find it? TIA Shawn Regan -Original Message- From: Andrew S. Peterson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 8:34 AM To: CF-Talk Subject: RE: VB6 Application, Cold Fusion Coral Hi Ben, I've been

Form Name as Variable?

2004-01-29 Thread Bailey, Neal
Hello all, This seems simple... but I can't figure it out... I need to set a Form Name as a variable. Example: if I have a form that generates a list like: stateForm1 = TX,CA,MI,UT,FL stateForm2 = TX,UT,FL stateForm3 = TX,WA How can I set stateForm1 as its own variable? Hope

Re: PGP Digital Signed Email

2004-01-29 Thread Thomas Chiverton
On Thursday 29 Jan 2004 15:33 pm, Robertson-Ravo, Neil (RX) wrote: OK, I know that using PGP and a CFX tag you can digitall sign emails in CF5..but whats required on the client end? Anything? Nope. PGP signatures are plain text. Of course, to be any use, the reciever needs to have something

RE: Form Name as Variable?

2004-01-29 Thread Raymond Camden
As its own variable? You mean a copy in the variables scope? You could just do: cfset variables.stateForm1 = form.stateForm1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Andrew S. Peterson
-Original Message- Sorry, Never heard of Coral. What is Coral and where can you find it? Shawn, From Defusion: Have you ever wanted to run Cold Fusion without Cold Fusion? Coral Web Application Builder is a new product that allows you to run Cold Fusion, (CFML) and portions of (ASP),

Request/application scope question

2004-01-29 Thread Critter
oi CF-Talk,!! i'm sure this has been asked many times in the past... i just cannot remember the answer... using CFMX. lets say i have four variables that do not change at all. i can place them in the application scope and it takes up the memory space for 4 variables, no? butifiduplicate the

RE: Request/application scope question

2004-01-29 Thread Barney Boisvert
Depends on what type of variables they are, and how you duplicate them.If you are duplicating to avoid having to use CFLOCK SCOPE=APPLICATION all over the place, then yes, you're doubling your memory. However, unless the variables are large, the memory use will be trivial. Cheers, barneyb

Re: Anyone ever see this?? SteelArrow?

2004-01-29 Thread Bryan Stevenson
Looks like a good old Canadian company.Gee we sure like to name stuff Arrow...SteelArrow...Avro Arrow ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] -

RE: Request/application scope question

2004-01-29 Thread Jim Davis
Basically, yes - you're using up the memory for each request.So, sort of, those four variables multiplied by the total number of allowable requests (threads) is you're upper limit. It's rarely enough to worry about it. If you're just going to be copying them to the request scope why put them

Re: Request/application scope question

2004-01-29 Thread Ubqtous
Critter, On 1/29/2004 at 12:32, you wrote: Cbutifiduplicate the application scope into the request C scope for each page hit... am i usingmore memory ? Is there any reason the variables need to be in the application scope to begin with? Seems like it would be simpler just to set them in the

RE: Calendar query?

2004-01-29 Thread Stefan Salzbrunn
Hi Hatton, What works is to JOIN with a table that has all the dates for your range in it, it will just display NULLs for the days that you don’t have any matching records. If you do not have such a table in your database, create a temp table on the fly... This should work in SQL Server (notice

Re: Request/application scope question

2004-01-29 Thread Critter
oi Ubqtous!! Thursday, January 29, 2004, 12:46:48 PM, you wrote: U Is there any reason the variables need to be in the application scope U to begin with? Seems like it would be simpler just to set them in the U request scope from the get-go... notreally, was just looking at tweaking little bits

Re: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
Hey Jochem, I am using Transact-SQL and converted everything but: UPDATE TABLE table SET shift_start = to_date( start_year || '-' || start_month || '-' || start_day, -mm-dd); I tried to do: UPDATE ONCALL_SHIFTS SET shift_start = CAST(start_monthstart_daystart_year AS DATETIME) But it is

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread DURETTE, STEVEN J (AIT)
Candace, This should be : update oncall_shifts set shift_start = cast((start_month + '/' + start_day + '/' + start_year) as datetime) Steve -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:28 PM To: CF-Talk Subject: Re: Dates

Replacing Characters

2004-01-29 Thread Eric Creese
I need to strip (double quote) out of a string of characters. I tried the following but it bombed. Can anyone steer me in the right direction? cfset newsym=replace(#qStockItems.Symbol#,,,ALL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Replacing Characters

2004-01-29 Thread Douglas.Knudsen
cfset newsym=replace(qStockItems.Symbol,'','','ALL') You can use single ticks.NOte, no need for the #s either. Doug -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:32 PM To: CF-Talk Subject: Replacing Characters I need to strip (double

RE: Replacing Characters

2004-01-29 Thread Nathan Strutz
You've got to double-up your double-quotes, or use single quotes to surround them... replace(qStockItems.Symbol,,,ALL) replace(qStockItems.Symbol,'','','ALL') both should work. -nathan strutz ps, you don't need #'s in your variables when they're inside cf functions or inside cfset and cfif

RE: Replacing Characters

2004-01-29 Thread Barney Boisvert
If you're inside a quoted string, you have to escape quotes by doubling them (just like hashes inside CFOUTPUT). cfset newsym=replace(#qStockItems.Symbol#,,,ALL) note the doubling ^^ You can also use the other kind of quote (double/single) to wrap your string to avoid the problem: cfset

Re: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread David Delbridge
Yeah.Why call it SteelArrow when they could've instead called the thing CrustyFriend, CreepFest, CanardFoil, etc., etc. and saved us some work? Too obtuse?How 'bout ChillyFission? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2235) Outside

RE: Replacing Characters - SOLVED

2004-01-29 Thread Eric Creese
Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 12:38 PM To: CF-Talk Subject: RE: Replacing Characters cfset newsym=replace(qStockItems.Symbol,'','','ALL') You can use single ticks.NOte, no need for the #s either. Doug

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
Hey Steve! I tried that one as well. I kept getting: Syntax error converting the varchar value '/' to a column of data type int. So then I went to: update oncall_shifts set shift_start = cast((start_month + start_day + start_year) as datetime) and got: Maximum stored procedure, function,

Re:How to Pass Varibles on Multipage Form?

2004-01-29 Thread Justin Jefferson
Thanks for your help, I was able to pass variables across pages. I had to take few bits out that were specific to my app. I hope it still runs as it should. You should probably name contactNew structure more specific to your app. The structDelete(contactNew.form, BTNSUBMIT); stuff is just so I

MS to change how IE handles URL parameters

2004-01-29 Thread Kevin Graeme
Microsoft plans to release a software update that modifies the default behavior of Internet Explorer for handling user information in HTTP and HTTPS URLs. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q834489 Basically, they're taking out the http://user:[EMAIL PROTECTED] format for

Obtaining Request URL

2004-01-29 Thread Jamie Jackson
Just curious, is there a way to get the entire requested URL in CFMX? That is, *not* a manually pieced-together string of cgi vars? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Calendar query?

2004-01-29 Thread Ian Skinner
I provide an answer for this in another thread, my example was even based on a table of holidays just like you are looking for.As once mentioned, you can create in temporary table to join against the table with the dates.I did mine inline.This is an oracle base example, but I'm sure a similar

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread DURETTE, STEVEN J (AIT)
Doh. Try this: update oncall_shifts set shift_start = cast((cast(start_month as varchar) + '/' + cast(start_day as varchar) + '/' + cast(start_year as varchar)) as datetime) sorry about that. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Paul Kenney
Or how about ColdFizzle?They have some interesting tags and functions, but they have a long time to go before they even come close to ColdFusion. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Shawn Regan
Yes, there has been some projects that we could of used Coral. We just ended up doing the application in VB with SOAP. Shawn Regan Head Applications Developer pacifictechnologysolutions -Original Message- From: Shawn Regan Sent: Thursday, January 29, 2004 9:16 AM To: CF-Talk Subject:

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
Thanks Steve :) That was one of the problems. The other was that there was a trigger on the column. I had to remove it before running the update. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293

RE: Obtaining Request URL

2004-01-29 Thread Ben Densmore
You could just use _javascript_. That way it wouldn't matter what version of CF you are using. Ben -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:59 PM To: CF-Talk Subject: Obtaining Request URL Just curious, is there a way to get

CF Eclipse plug-in sourceforge

2004-01-29 Thread Rob Rohan
For some reason ... ahem ... the cfeclipse plug-in project got rejected on sourceforge as a viable project. Odd. Wonder why that happened. So I'll have to go it alone it seems, I will post the source code on the http://cfeclipse.rohanclan.com site in a bit - perhaps I'll setup my own CVS server

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
I think I figured out this error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). I update the field. The trigger is called. The trigger updates the field. The trigger is called. The trigger updates the field. The trigger is called.The trigger updates the

RE: Best practises question

2004-01-29 Thread Taco Fleur
cfif edible Is the easiest to write, however not the fastest to execute cfif variables.edible EQ TRUE executes faster And its best practice to always scope your variables. cfset arr_fruit=ArrayNew(1) cfset arr_fruit[1]=apple cfset arr_fruit[2]=banana cfset arr_fruit[3]=pear cfset

Re: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Jochem van Dieten
Candace Cottrell wrote: Hey Jochem, I am using Transact-SQL Sorry, thought you were on Oracle. The idea should work just the same, but I will leave the exact syntax to people with more T-SQL experience ;-) Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays

How to Pass Varibles on Multipage Form?

2004-01-29 Thread hadi_cf
In ColdFusion mx bible, a solution for this is discussed using CFCs (ColdFusion Components), I love this way, and use this ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Best practises question

2004-01-29 Thread Tom Kitta
You are incorrect to state that cfif variables.edible EQ TRUE executes faster. I did a small test with code underneath and in most executions it is faster to do cfif edible. I always wondered to see what the difference would be without using EQ. In some runs it was even 200%. On average it looks

RE: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Andrew S. Peterson
it would seem strange to type anything else other than CF... or CFA_ Yes, but it seems you get to keep on using those pound signs! TH COLSPAN=2I#PARAM.first+1# to #PARAM.first+3# of #SESSION.faqQuery.RowCount()#/I/TH Sincerely,   Andrew [Todays Threads] [This Message] [Subscription]

Re: Best practises question

2004-01-29 Thread Jochem van Dieten
Taco Fleur wrote: cfset arr_fruit=ArrayNew(1) cfset arr_fruit[1]=apple cfset arr_fruit[2]=banana cfset arr_fruit[3]=pear cfset edible = ArrayAppend(arr_fruit,pineapple) I also not sure that your example really displays correctly, i.e. you are creating an array and in the cfif example you

RE: Dates - ranges overlapping months... rut-roh

2004-01-29 Thread Candace Cottrell
Nevermind... I found it after I RTFM for almost an hour ;) Here's what you do to turn off Nested Triggers in SQL Server 2000. USE master EXEC sp_configure 'nested triggers', '0' RECONFIGURE WITH OVERRIDE Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza

RE: Best practises question

2004-01-29 Thread Taco Fleur
OK, you are right, I wasn't paying much attention there, it's early here in Oz..!! I'm still pretty sure cfif edible EQ true executes faster, as I have done tests, and have seen tests out there that state so, even so, I use cfif edible myself. Taco Fleur

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Nathan Mische
Awesome, I've been looking for an Eclipse plug-in for CFML. Thanks Rob. --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Andre Turrettini
they gave no reason?I've seen a couple of cf and non cf projects far less deserving. How hard is it to code for eclipse? Whats the language? DRE -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 12:29 PM To: CF-Talk Subject: CF Eclipse plug-in

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Rob Rohan
On Thu, 2004-01-29 at 13:46, Andre Turrettini wrote: they gave no reason?I've seen a couple of cf and non cf projects far less deserving. No, they didn't. Rather odd too as I already have a couple project on the site that are pretty active and drive quite a bit of traffic to their site (not to

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Katz, Dov B (IT)
Hmm.There's even source code already. That's more deserving than about 50% of sf projects right off the bat :) PS - Has anyone got the SF (alexandria-dev) build running on their own server? Just curious -d _ From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Thursday, January

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Katz, Dov B (IT)
BTW - Anyone recommend a good FTP plugin for ecplise?-d _ From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 4:52 PM To: CF-Talk Subject: RE: CF Eclipse plug-in sourceforge On Thu, 2004-01-29 at 13:46, Andre Turrettini wrote: they gave no reason?I've seen

RE: CF Eclipse plug-in sourceforge

2004-01-29 Thread Rob Rohan
the only one I have seen is the FTP/WEBDav one - its on the same page as the download for eclipse - about half way down the page. If you find another one I'd love to know too :) On Thu, 2004-01-29 at 13:57, Katz, Dov B (IT) wrote: BTW - Anyone recommend a good FTP plugin for ecplise?-d _

OT: Storing SQL SP's in VSS]

2004-01-29 Thread Dan O'Keefe
I want to store my MSSQL 2K(SP3a) SP's in VSS and trying to think of a way to do it. First thought was to find an existing system SP if it existed, that I could loop over all of the SP's and just retrieve the text of the SP, not execute it. I could then write those out to text files. Also took

Changing HTML text to images

2004-01-29 Thread Stuart Kidd
Hi guys, Instead of displaying someone's userid in plain html text I'd like to replace each character with my own images.E.g. instead of the number 1 I'll have 1.gif, instead of 2 I'll have 2.gif.This way I can use my funky font. Two questions, (1) Say if there is always going to be 8 digits

RE: OT: Storing SQL SP's in VSS

2004-01-29 Thread Suyer, Ed
Why not just select the SP, generate script, then stored the generated script in a VSS project. If you need to make a change, c/o the script, make your change, execute it, then check it back in. If you find a tighter integration then this, I'd like to hear about it.But that's what we do here.

RE: MS to change how IE handles URL parameters

2004-01-29 Thread Dave Watts
Microsoft plans to release a software update that modifies the default behavior of Internet Explorer for handling user information in HTTP and HTTPS URLs. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q834489 Basically, they're taking out the http://user:[EMAIL PROTECTED]

  1   2   >