RE: Looping....again

2004-09-22 Thread Pascal Peters
You need the quotes. CFHTTP should take care of them! Pascal -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 04:04 To: CF-Talk Subject: RE: Loopingagain i think 1st thing to do is run a script to get rid of all the quotes probably use the

RE: Looping....again

2004-09-22 Thread Pascal Peters
I'm coming in late, so maybe you already have a solution. This should help you create your prescriptions. I would create an array of prescriptions (not in the code). Each prescription should be a structure of patient info, doc info and an array of drug info. cfhttp url="" name=q1

Re: Looping....again

2004-09-22 Thread Stephen Moretti (cfmaster)
dave wrote: i think 1st thing to do is run a script to get rid of all the quotes probably use the replace function Not neccessary Thats what the textdelimiter attribute of CFHTTP is for. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

Re: Prepared Statements in CFMX

2004-09-22 Thread Paul Kenney
Well, it does do the same thing. The only difference is that you use cfquery instead of using the JDBC API directly.In fact, if you use cfqueryparam, the database turns your query is turned into a prepared statement the first time it is called and sends back a handle to the JDBC driver.For all

Re: Looping....again

2004-09-22 Thread Stephen Moretti (cfmaster)
Brant, My CFX_PDF tag don't work inside the loops though :-( so I think I am gonna have to go back to trying to build this data into another set of DB tables, but each drug given a script number so that I can then query the data based on the doctors name, and then build the scripts

Seeking Italian CF brain

2004-09-22 Thread Jack Dalaa
Hi all, I'm in semi-urgent need of a CF developer, who's: - Italian - speaks (or at least writes) English well - experienced with integrating Gestpay and Mobilmat payment processing into a CF site I don't speak any Italian, but I'm building a CF site for an Italian client in Italy, and have

Tiem Format problems

2004-09-22 Thread Seamus Campbell
hi I'm trying to pull a date/time from a database then add 17 hours to it and display in dd mmm h n format I thought I could add 17 hours to the date using DateAdd but this seems to have problems with the format and I can't work out how to get the time to be plus 17 hours Or is there

Re: Tiem Format problems

2004-09-22 Thread Andrew Dixon
Hi. This works. cfset plus17h = DateAdd(h, 17, now()) cfoutput #DateFormat(plus17h, dd/mm/)# #TimeFormat(plus17h, HH:MM)# /cfoutput Andrew - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 19:36:48 +1000 Subject: Tiem Format problems To: CF-Talk

RE: Tiem Format problems

2004-09-22 Thread James Smith
Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

[Reply To] Re: Tiem Format problems

2004-09-22 Thread Seamus Campbell
thanks (wow very quick reply!) however I get this message when I try and use my date in the database ( rather than Now() ). Entity has incorrect type for being called as a function. The symbol you have provided date_last_modified is not the name of a function. Any clues? You

[Reply To] RE: Tiem Format problems

2004-09-22 Thread Seamus Campbell
Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: [Reply To] RE: Tiem Format problems

2004-09-22 Thread Andrew Dixon
Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there

Re: [Reply To] RE: Tiem Format problems

2004-09-22 Thread Andrew Dixon
Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED]

[Reply To] Re: [Reply To] RE: Tiem Format problems

2004-09-22 Thread Seamus Campbell
It's Date/Time in Access Ta seamus You wrote Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk

[Reply To] Re: [Reply To] RE: Tiem Format problems

2004-09-22 Thread Seamus Campbell
2004-09-21 22:06:13.0 Ta Seamus You wrote Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Is your data and a date or a datetime? Andrew.

RE: Tiem Format problems

2004-09-22 Thread Pascal Peters
This works in cfmx 6.1 cfset date = 2004-09-21 22:06:13.0 cfset plus17h = DateAdd(h, 17, date) cfoutput #DateFormat(plus17h, dd mmm )# #TimeFormat(plus17h, HH:MM)# /cfoutput It doesn't work on CF5 though (it fails on the .0) On cf5 you could do a workaround cfset date = 2004-09-21

Re: relational display

2004-09-22 Thread Deanna Schneider
Well, I didn't actually write any queries using your naming conventions before. ;) I wasn't trying to be rough, just offering an opinion. Naming conventions are something of a religion for some people, and I'm not of that camp. But, I do find that being clear and consistent helps tremendously.

Re: relational display

2004-09-22 Thread Deanna Schneider
Dan, Let's walk through what the query is doing SELECT p.p_question, a.pa_answer, COUNT(r.pv_poll_answer) AS total !--- Get each question, each answer, and the total number of responses for each answer --- FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r !--- we're gathering

Verity

2004-09-22 Thread Trevor Holm-Laursen
Hey all, We've decided to finally try verity as the search on our client sites.I can create and index site files and queries, but am lost on how to organize it all.Should I create a separate collection for each database table I want to index or simply use a custom field to put the type of record

[Reply To] RE: Tiem Format problems

2004-09-22 Thread Seamus Campbell
Fantastic - thanks very much Seamus You wrote This works in cfmx 6.1 cfset date = 2004-09-21 22:06:13.0 cfset plus17h = DateAdd(h, 17, date) cfoutput #DateFormat(plus17h, dd mmm )# #TimeFormat(plus17h, HH:MM)# /cfoutput It doesn't work on CF5 though (it

windows, services, and the JMC

2004-09-22 Thread Douglas Knudsen
We are using the J2EE way on JRunI noticed an issue that maybe some of you can comment on.If I start the CF server via the JRun JMC it does not seem to start the registered service as seen in the windows services MMC.Actually, I can have two jrun.exe processes for the same CF server!I just

Re: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Thomas Chiverton
On Wednesday 22 Sep 2004 03:21 am, Matt Liotta wrote: What library do I use to create the vector graphics? We use one from http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm (typicaly, this site is down atm :-)). We're doing basicaly the same thing - retrive a map from a map server and then

Session variable works one line and not another?

2004-09-22 Thread Damien McKenna
Can anyone please help me work out why the second line would ever fail with the message Element REPLICANT is undefined in SESSION.? cfif StructKeyExists(Session, Replicant)cfif IsStruct(Session.Replicant) cfif StructKeyExists(Session.Replicant, Name)h4#Session.Replicant.Name#/h4/cfif /cfif I

RE: HTTPS Upload of a file.

2004-09-22 Thread James Smith
So does anyone know of a command line application for https upload? -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 16:10 To: CF-Talk Subject: RE: HTTPS Upload of a file. That is something I want to avoid as there is no way of referencing

ot: sql question

2004-09-22 Thread Tony Weeg
is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message]

Re: sql question

2004-09-22 Thread Paul Hastings
correct (if you mean for sql server) is it true that we cannot use go in sql statements using cfquery? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: HTTPS Upload of a file.

2004-09-22 Thread Thomas Chiverton
On Wednesday 22 Sep 2004 14:55 pm, James Smith wrote: So does anyone know of a command line application for https upload? Well, curl :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole

RE: sql question

2004-09-22 Thread Robertson-Ravo, Neil (RX)
I don't think so no, but GO is not required in SQL, it can be ommited. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 14:59 To: CF-Talk Subject: ot: sql question is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia

Re: Zip files

2004-09-22 Thread Sudha Prasannappa
I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: sql question

2004-09-22 Thread Tony Weeg
it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a GO heres what im doing... we are using a distributed partitioned view, and when we make table

RE: HTTPS Upload of a file.

2004-09-22 Thread James Smith
I am assuming you have read the first few messages in this thread and are being sarcastic, if so then Ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ;-) -- Jay -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:09 To:

RE: sql question

2004-09-22 Thread Robertson-Ravo, Neil (RX)
Well, really it should be an SP. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:34 To: CF-Talk Subject: Re: sql question it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must

Re: Zip files

2004-09-22 Thread Mark Drew
cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does

RE: Zip files

2004-09-22 Thread Robertson-Ravo, Neil (RX)
Cfx_zip www.forta.com _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To: CF-Talk Subject: Re: Zip files cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED]

RE: Zip files

2004-09-22 Thread James Smith
I seem to remember Ben having written a custom tag for CF4 for zipping files and directories but I don't seem to be able to find it, anyone else remember or am I imagining it? -- Jay -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To:

RE: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Beal, Jason
Alternatives to Thomas' suggestion which is a _javascript_ library that draws vectors by using many divs or layers to represent pixels and groups of pixels options for drawing vectors client side include: VML - (IE 5.0+ with the VML option installed) SVG - (requires plugin from Adobe) Flash

RE: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Matt Liotta
The problem isn't drawing the vectors; it is drawing them in context of the map. For example, drawing a circle with a radius of 1 mile with a center of x/y (lat/long). -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beal, Jason Sent: Wednesday,

Re: OT: JS Gateway Question

2004-09-22 Thread Dan O'Keefe
Hi Mike, Did you check with Dan Switzer? Does he have a yahoo group for the gateway as he does for qForms? Dan - Original Message - From: Tangorre, Michael [EMAIL PROTECTED] Date: Tue, 21 Sep 2004 17:31:37 -0400 Subject: OT: JS Gateway Question To: CF-Talk [EMAIL PROTECTED] I am still

Re: sql question

2004-09-22 Thread Michael Traher
I wonder if SQLBATCHER on CFLIB may help - just looked at this this morning! http://www.cflib.org/udf.cfm?id=1127 On Wed, 22 Sep 2004 10:33:55 -0400, Tony Weeg [EMAIL PROTECTED] wrote: it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to

Query/DB design problem

2004-09-22 Thread Daniel Kessler
I recently asked how to structure a query to request poll results from my db. I've listed the db structure and the query below. The problem that I now have is that it only lists poll answers that have been answered once.I know that this is because it's querying the Results table

RE: Prepared Statements in CFMX

2004-09-22 Thread Dave Watts
Yes, i have looked at cfQueryParam. I dont think it works the same as below. http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedState ment.html Yes, that's exactly what it does. The CFQUERYPARAM tag creates a prepared statement. If you look at your debug output when using CFQUERYPARAM,

RE: OT: JS Gateway Question

2004-09-22 Thread Tangorre, Michael
From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Hi Mike, Did you check with Dan Switzer? Does he have a yahoo group for the gateway as he does for qForms? Hi Dan, I inquired about the gateway email list and Dan S. said to use the qForms emal list for JS Gateway questions... which I have done

Re: Prepared Statements in CFMX

2004-09-22 Thread Ken Wilson
Would that have something to do with the error I get if I run a query using cfqueryparam , make a slight change to database structure and then run the query again? If I remove the cfqueryparam it works fine and if I wait awhile before running the query again it does fine. Almost acts like it's

RE: sql question

2004-09-22 Thread Jason Reichenbach
Turn it into a Stored Procedure and just call the stored procedure. Either using cfquery or cfstoredproc. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:34 AM To: CF-Talk Subject: Re: sql question it cant be ommitted when creating a view and you do that

RE: Prepared Statements in CFMX

2004-09-22 Thread Dave Watts
Would that have something to do with the error I get if I run a query using cfqueryparam , make a slight change to database structure and then run the query again? If I remove the cfqueryparam it works fine and if I wait awhile before running the query again it does fine. Almost acts

Re: relational display

2004-09-22 Thread daniel kessler
The only thing that I didn't get was the first line of the WHERE p.p_id = a.pa_pollID.It seems that if I have the last AND p.p_id = 21, then I shouldn't need that first line, but I do.I am told by several that it's because it connects the pollID to the answerId and I know that they're correct

Re: Prepared Statements in CFMX

2004-09-22 Thread Ken Wilson
As much as I hate SELECT * , I am using it in this case on some admin pages rather than code individual queries for each table...pure laziness.Never noticed that behavior under CF5 using ODBC. Thanks, Ken On Wed, 22 Sep 2004 12:13:29 -0400, Dave Watts [EMAIL PROTECTED] wrote: Would that have

What Pages are being Parsed

2004-09-22 Thread Robertson-Ravo, Neil (RX)
Is there a way in CFMX to see/get what Pages are being parsed in real-time? We are trying to debug a problem due to load and Jrun connection errors and want to see where and when the problem is occurring.. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey,

Re: Session variable works one line and not another?

2004-09-22 Thread Nathan Strutz
Could it be a locking issue? do you structDelete(session,Replicant), or structClear(session)? I have often experienced this where a user double-clicks a button or link. -nathan strutz http://www.dopefly.com/ Damien McKenna wrote: Can anyone please help me work out why the second line would

QueryString

2004-09-22 Thread Ciliotta, Mario
Hi, Is there anyway to get the text of the query that is being executed.I have a page that the query is being pieced together thru the use of dropdowns and so on and the problem that I am having is that certain query will return a large amount of records (@50,000) and I want to capture every

Re: windows, services, and the JMC

2004-09-22 Thread Nathan Strutz
Yes, this is normal behavior. I suggest using the services panel to start and stop your server, unless you just happen to be in the JMC and just want to restart your server. This way, the services panel doesn't get confused as to what is and is not running. Also, when you say you have 2

RE: QueryString

2004-09-22 Thread Tangorre, Michael
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. #CGI['QUERY_STRING']# Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: windows, services, and the JMC

2004-09-22 Thread Douglas Knudsen
ah, ok.I actually have 4 servers running, Default, Admin, CF, and another CF named Portal.So 4 servers running.If I use a combo of the JMC and the services MMC I can end up with 5 or more jrun.exe processes. I have custom jvmconfigs for each, if I use the JMC to start/stop each does it use the

passing from java to cf

2004-09-22 Thread Doug James
I have written a java class that crawls our site compiles a list of links. I then populate a cf array from a java method that returns a java vector. The crawling portion appears to take a couple of minutes, no surprise, but I am stopping the population of the array after 15 minutes. Any

Re: QueryString

2004-09-22 Thread Doug James
If you are piecing it together into a variable, can't you just use cfmail to send it to you right before you submit the variable to the cfquery? Doug Ciliotta, Mario wrote: Hi, Is there anyway to get the text of the query that is being executed.I have a page that the query is being pieced

Re: QueryString

2004-09-22 Thread Nathan Strutz
There's a few things you can do... 1) enable debugging, then check your [..]\WEB-INF\debug\ folder for insight into the cfdebug structure. I think you can probably just cfdump var=#cfdebug_queries# to get a visualization, then use that to get at all the variables you want. 2) rewrite your sql

Re: QueryString

2004-09-22 Thread Dave Carabetta
On Wed, 22 Sep 2004 13:09:13 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. #CGI['QUERY_STRING']# That won't work.

Using Sun's JVM

2004-09-22 Thread Jordan Michaels
Greetings, Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? Thanks! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message]

RE: QueryString

2004-09-22 Thread Tangorre, Michael
From: Dave Carabetta [mailto:[EMAIL PROTECTED] That won't work. CGI.query_string is for returning anything passed via the URL. I know... I misread what he was asking for. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Using Sun's JVM

2004-09-22 Thread Dave Carabetta
On Wed, 22 Sep 2004 10:24:51 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Greetings, Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? We're using 1.4.2_05 and it's been fine. No issues whatsoever. I'm

RE: What Pages are being Parsed

2004-09-22 Thread Dawson, Michael
How about using CFLOG in the application.cfm file?You can write the date/time and the template path as well as any other relevant information. Or, use application.cfm to save the same information to a database. From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL

Re: Using Sun's JVM

2004-09-22 Thread Paul Hastings
Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? had it on both. currently on 1.5. seems fine. we're mostly interested in i18n stuff so we haven't tested it for speed, etc. but nothing bad has happened (yet).

Boxed Cart Solution?

2004-09-22 Thread Donna French
I have a new client that wants their site up yesterday (as usual). What ready to go solution would you all recommend - something reasonably priced for small business? Would like to stay with CF but would consider ASP.NET. TIA, Donna -- Donna French [EMAIL PROTECTED] [Todays Threads] [This

RE: REPOST: First time Web Service

2004-09-22 Thread Ian Skinner
This has actually been resolved.It turned out to be white space from an Application.cfm file in the same directory as the web service CFC file.I would never have guessed it from the error message, but I just started throwing the web service up on every server I had access to, and got a different

SQL: Passing vars to a LIKE statement

2004-09-22 Thread Eric Creese
I need to pass some varibles into a LIKE clause in a SELECT statement. I am having trouble with the format. AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this is wrong cause it see that garb as a literal string. How do I pass this so the vars show? [Todays Threads]

RE: Prepared Statements in CFMX

2004-09-22 Thread Dave Watts
As much as I hate SELECT * , I am using it in this case on some admin pages rather than code individual queries for each table...pure laziness.Never noticed that behavior under CF5 using ODBC. It will only occur if you change the database structure and you're using an existing query plan

Re: Boxed Cart Solution?

2004-09-22 Thread Tyler Fitch
Donna, Check out CartWeaver - http://www.cartweaver.com/ or Able Commerce http://www.ablecommerce.com/AbleCommerce-ColdFusion-MX-Shopping-Cart-P41C20.aspx Good luck, t On Wed, 22 Sep 2004 12:46:17 -0500, Donna French [EMAIL PROTECTED] wrote: I have a new client that wants their site up

refresh inserts my form content

2004-09-22 Thread Daniel Kessler
I posted this on cf-newbies, but didn't understand the answer, nor could I get another solution to work. I have a form that goes to a page which updates a database.I check to see if the form exists and that an answer exists so that the database will be updated.Unfortunately, when I refresh the

RE: Zip files

2004-09-22 Thread Ewok
Yes he did. CFX_Zip _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:49 AM To: CF-Talk Subject: RE: Zip files I seem to remember Ben having written a custom tag for CF4 for zipping files and directories but I don't seem to be able to find it, anyone else

Re: Using Sun's JVM

2004-09-22 Thread Jordan Michaels
Thanks Paul and Dave for your feedback. I have a customer who has continually had problems with JRun. The latest of which has to do with a JRun Garbage Collecting memory leak - thus making his otherwise ample server run out of memory, lock-up and crash like a fireball from heaven. =P More info

Re: refresh inserts my form content

2004-09-22 Thread Charlie Griefer
one solution is to use a 3-page approach. form page - update page - thank you page the form page is self-explanatory.contains your form. the update page has your updat query in it.once the query succeeds, do a cflocation to... the thank you page.this is the page that lets your user know the

Re: refresh inserts my form content

2004-09-22 Thread dave
of course it does that, but not a cfm prob a html prob what r utrying to do? see the info after it has been updated? if thats the case dont send it back to the form processing page, do u have the form and the processing code on the same page? -- Original Message

Re: SQL: Passing vars to a LIKE statement

2004-09-22 Thread Ali Awan
I need to pass some varibles into a LIKE clause in a SELECT statement. I am having trouble with the format. AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this is wrong cause it see that garb as a literal string. How do I pass this so the vars show? Eric, I

Re: SQL: Passing vars to a LIKE statement

2004-09-22 Thread Brett Barnhart
I need to pass some varibles into a LIKE clause in a SELECT statement. I am having trouble with the format. AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this is wrong cause it see that garb as a literal string. How do I pass this so the vars show? Here is

Re: Using Sun's JVM

2004-09-22 Thread Dave Carabetta
On Wed, 22 Sep 2004 11:10:49 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Thanks Paul and Dave for your feedback. I have a customer who has continually had problems with JRun. The latest of which has to do with a JRun Garbage Collecting memory leak - thus making his otherwise ample server

RE: Zip files

2004-09-22 Thread Dave Francis
Iuse CFX_Zip. I've experienced problems trying to open its archives using PKZip. WinZip works fine. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 2:08 PM To: CF-Talk Subject: RE: Zip files Yes he did. CFX_Zip _ From: James Smith

RE: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Beal, Jason
To do this you have to define the real world extent of your map/image then calculate the origin and radius of your circle. mapMaxX, mapMinX //these are the minimum and maximum values for the real world X coordinates imageWidth //the width of your image in pixels mapPointX //the real world X

Re: Boxed Cart Solution?

2004-09-22 Thread Adam Haskell
If you search the HoF archeives you'll find some fairly reacent posts about Shopping Cart solutions. The newest version of Ablecom is not available for CF but it is for ASP. The latest version for CF is not much CF honestly it is mostly coded in Java classes, so if no one is comfortable with Java

Re: Using Sun's JVM

2004-09-22 Thread Jordan Michaels
Dave Carabetta wrote: Have you tried JRun Updater 4 yet? I haven't, but I know it does have a lot of fixes in there, particularly with regards to leaks. No, but it's just a stand-alone Cold Fusion MX installation. We have applied the CFMX 6.1 updater (released August 25) so I'm assuming that

Re: CFC - Web service error handling

2004-09-22 Thread Adam Haskell
I return XML with all my webservices so if an error occures I just return that in xml... xmldoc error errorcode/errorcode errormessage/errormessage /error xmldoc Adam H On Tue, 21 Sep 2004 21:57:56 -0400, Rick Root [EMAIL PROTECTED] wrote: Ian, ALL of my web services return a CFC object,

Re: Using Sun's JVM

2004-09-22 Thread Dave Carabetta
On Wed, 22 Sep 2004 11:48:50 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Dave Carabetta wrote: Have you tried JRun Updater 4 yet? I haven't, but I know it does have a lot of fixes in there, particularly with regards to leaks. No, but it's just a stand-alone Cold Fusion MX

SOT: Windows to Unix Link capitalization problem

2004-09-22 Thread E C list
Does anyone know of a tool that will look for capitalization of file names in URL links and convert them to lower case?We need to transfer a site to a UNIX server and we're having a problem with the case of some of the links.The site has about 40 pages.

Re: SOT: Windows to Unix Link capitalization problem

2004-09-22 Thread Damien McKenna
E C list wrote: Does anyone know of a tool that will look for capitalization of file names in URL links and convert them to lower case? Look up how to do URL rewriting (mod_rewrite in apache). -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company -

Re: refresh inserts my form content

2004-09-22 Thread Greg Morphis
before you insert your values into the database, check for the existence of the primary key.. On the form page you have your primary key.. it's passed as a hidden variable to the proccessing page. before you do your cfquery name=insert INSERT INTO TABLE_NAME VALUES() /cfquery check for the

Re: ot: sql question

2004-09-22 Thread Qasim Rasheed
As far as I know you cannot. - Original Message - From: Tony Weeg [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 09:59:03 -0400 Subject: ot: sql question To: CF-Talk [EMAIL PROTECTED] is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia

RE: Query/DB design problem

2004-09-22 Thread Steve Brownlee
The query has to select the aggregrate and then outer join the related table. This is just a stab in the dark as to how the query would look, but if you can see what I'm trying to do, you can follow the concept to completion.I'm not a DBA so take this as a guideline and not the solution (unless,

Re: print output

2004-09-22 Thread Qasim Rasheed
How about this http://gilgamesh-solutions.com/products.cfm#p1 - Original Message - From: Brant Winter [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 15:00:32 +1000 Subject: RE: print output To: CF-Talk [EMAIL PROTECTED] Timeframe : 6 months ago - like everything else round here. _ From:

Re: windows, services, and the JMC

2004-09-22 Thread Nathan Strutz
Douglas Knudsen wrote: ah, ok.I actually have 4 servers running, Default, Admin, CF, and another CF named Portal.So 4 servers running.If I use a combo of the JMC and the services MMC I can end up with 5 or more jrun.exe processes. I would ditch the default server, unless you use it. Also,

RE: CFC - Web service error handling

2004-09-22 Thread Steve Brownlee
This solution works well since most complex ColdFusion data types aren't handled well when passed via a webservice.I convert almost everything in a CFC to an XML string before returning it and also have the error code and description in XML.That way I know that no matter what, I'm looking for a

Re: ot: jrun ?

2004-09-22 Thread dave
i turned it down from 512 mb to 128 mb and now it wont even start lol -- Original Message -- From: Dave Carabetta [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 21 Sep 2004 12:43:17 -0400 On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame [EMAIL

RE: SQL: Passing vars to a LIKE statement

2004-09-22 Thread Eric Creese
thanks, but I am doing this in sql stored proc not a cf page. forgot to mention this -Original Message- From: Brett Barnhart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 1:22 PM To: CF-Talk Subject: Re: SQL: Passing vars to a LIKE statement I need to pass some varibles

debug question

2004-09-22 Thread Jason Reichenbach
Is there a function out there that mimics CF's Debug? I'm looking for something along these lines to provide in an email. The function would have to act almost exactly as CF's dbug? TIA Jay Reichenbach [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Beal, Jason
To convert a radius from real world coordinates to a coordinate on the image you can use the following to first find the origin point on the map then find the length in pixels of the radius. mapMaxX, mapMinX //these are the minimum and maximum values for the real world X coordinates imageWidth

JAVASCRIPT and textarea

2004-09-22 Thread Asim Manzur
I have form with TextAreaand _javascript_, which doesn't allow user to hit enter key and |. The below code is working fine, but if user cut/paster from word or notepad then textbox accept the enter key and pipe. Can someone advise anyway to prevent that?? script language=_javascript_ function

RE: SQL: Passing vars to a LIKE statement

2004-09-22 Thread Eric Creese
thanks but it is not helping, here is my stored proc and the error msg I receive CREATE PROCEDURE GetMonthlyJoins AS DECLARE @MONTH varchar(3), @MONTHNBRint, @YEARint, @did datetime, @countint, @likevar varchar(25) IF object_id('#MonthlyJoins') is not null BEGIN TRUNCATE TABLE

RE: SQL: Passing vars to a LIKE statement

2004-09-22 Thread Jason Reichenbach
Pass the percent signs as part of your var... Don't know why it works but it does. There is a way to do it in a stored proc but I don't remember off the top of my head. _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 4:15 PM To: CF-Talk Subject: RE: SQL:

ODBC more unstable with CFMX 6.1 Updater?

2004-09-22 Thread Damien McKenna
I've noticed that the ODBC gateway in the 6.1 Updater seem to be more unstable than the 6.1 ones, at least when using the AcuODBC driver at the ODBC side.Has anyone else noticed anything similar? -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company

RE: JAVASCRIPT and textarea

2004-09-22 Thread Dawson, Michael
Instead of checking for these characters while they are typing or pasting, why not just replace them with nothing when they submit the form? From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 3:16 PM To: CF-Talk Subject:

RE: JAVASCRIPT and textarea

2004-09-22 Thread Tangorre, Michael
From: Asim Manzur [mailto:[EMAIL PROTECTED] I have form with TextAreaand _javascript_, which doesn't allow user to hit enter key and |. The below code is working fine, but if user cut/paster from word or notepad then textbox accept the enter key and pipe. Can someone advise anyway to

Re: dynamic maps (GIS and other acronyms)

2004-09-22 Thread Simon Horwith
ordinarilly when it comes to generating dynamic and/or rich interfaces I recommend Flash, but for something like this, I'd recommend using SVG - there are even plenty of open source SVG java packages that might help you get started. ~Simon Simon Horwith Member of Team Macromedia Macromedia

  1   2   >