RE: EXTREMELY slow site, trying to troubleshoot

2004-08-04 Thread Jim Davis
Time the same call outside of ColdFusion - is it still that slow? It definitely seems something is wrong - if it's just as slow outside of CF then you can forget CF as a part of the problem and start troubleshooting your network and database. Let us know how it goes. Jim Davis From: mayo [mailt

Re: ListGetAt vs. ListToArray

2004-08-04 Thread Paul Kenney
The first thing I ask when someone poses a question like this is, "How often does this run?"  If it is a batch process that runs once a day during non-peak times, it does not matter how efficient it is.  It just has to get done in a timely manner.  Too many people will toil over finding the most el

RE: Mandarin... Internationalization, Localization

2004-08-04 Thread Hugo Ahlenius
Can there be a i18n/l10n thread without a post by Paul H? :) Disclaimer: this is not meant as a complaint, rather a recognition of your expertise and your helpful comments -- Hugo Ahlenius - Hugo Ahlenius  E-Mail: [EMAIL

Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
Hi How can I remove UNICODE characters from Coldfusion, is there a script/custom tag I can include to ensure that characters such as ' " - etc are displayed correctly and not as * * * [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and S

Fusion Authority Blackstone Article

2004-08-04 Thread dcooper
fyi..Blackstone article http://www.fusionauthority.com/Article1.cfm/ArticleID=4244 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Paul Hastings
> How can I remove UNICODE characters from Coldfusion, is there a > script/custom tag I can include to ensure that characters such as > ' " - etc are displayed correctly and not as * * * well that's more of case of how your app/server is setup (at least as far as mx goes). you really shouldn't *ne

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
Paul Why shouldnt you need to remove Unicode characters ?? As you will encounter non-standard characters. The most common example is an accent in someone's name, such as José or Jürgen, but another example is "smart quotes" inserted by Word. that will display on screen as the 'black outline

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Hugo Ahlenius
| As you will encounter non-standard characters. The most | common example is an accent in someone's name, such as José | or Jürgen, but another example is "smart quotes" inserted by | Word. that will display on screen as the 'black outline | square character' | | Is this problem only relevant to C

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
Ive tried the following at the top of the template, but it still displays the square character on certain characters such as ' " - From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 11:10 To: CF-Talk Subject: RE: Coldfusion & UNICODE Charac

Jrun error

2004-08-04 Thread James Smith
I am having a problem I haven't seen before and was wondering if anyone here knew what caused it and how to fix it. I have just built a new server, installed Win2003 server (standard), MySQL and ColdFusion.  Everything seems to work fine except that after about 2 minutes of uptime CF falls over wi

RE: Jrun error

2004-08-04 Thread Robertson-Ravo, Neil (RX)
Is this using the server config of CF (inbuilt JRun).    _   From: James Smith [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 11:22 To: CF-Talk Subject: Jrun error I am having a problem I haven't seen before and was wondering if anyone here knew what caused it and how to fix it. I have j

Re: Interesting Error...

2004-08-04 Thread Thomas Chiverton
On Tuesday 03 Aug 2004 23:19 pm, Tangorre, Michael wrote: > Anyone seen this? > TYPE: java.lang.ArrayIndexOutOfBoundsException > MESSAGE: 6>=6 Well, yes. What is the line of code generating the error ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECT

RE: Jrun error

2004-08-04 Thread James Smith
Yup. > -Original Message- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 04 August 2004 12:25 > To: CF-Talk > Subject: RE: Jrun error > > Is this using the server config of CF (inbuilt JRun). > >   > >   > >    _   > > From: James Smith [mailto:[EMAIL PRO

Re: Trying to uplaod a file using CFFILE, I am getting an error...

2004-08-04 Thread Doug James
If I am totally wrong just ignore my suggestion: It looks like you are trying to do some parsing of the uploaded filename. I recently needed to perform similar processing and here is what I did: - I let the user upload the file using a file type html input - my submit button called a _javascript

Re: EXTREMELY slow site, trying to troubleshoot

2004-08-04 Thread Joe Rinehart
Hey Gil, I had a similar issue with a site I set up on a shared hosting server - even super-simple queries were at least 4 seconds.  What I found is that they had disabled the "Maintain Connections" setting for the datasource.  You'll find it under ColdFusion Administrator -> Data Source -> Your D

Sorting by aggregate functions

2004-08-04 Thread James Smith
I have a situation where I need to sort a query by an aggregate function, ie: SELECT   d.ItemID, d.Title, sum(i.Quantity) AS Quantity FROM SomeTables GROUP BY d.ItemID, d.Title ORDER BY sum(i.Quantity) However this does not work and tells me I have an "Invalid use of group function".  So far

Flash Remoting

2004-08-04 Thread Cutter (CF-Talk)
Is Flash Remoting automatically loaded with CFMX 6.1? If so, why don't I have a flashservices/gateway folder anywhere? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: Sorting by aggregate functions

2004-08-04 Thread James Smith
Never mind, sorting by Quantity did it.  I was sure I had already tried this with no results but hey... Sorry to waste all of your time. -- Jay > -Original Message- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: 04 August 2004 13:34 > To: CF-Talk > Subject: Sorting by aggregate f

Re: Flash Remoting

2004-08-04 Thread Scott Stroz
If you can browse to yourdomain.com/flashservices/gateway without getting a 404 error, it is loaded. If you get a 404 error, than the connector for the site is not configured properly.  You can find files to fix this issue in cf-root/bin/connectors...just use the files that pertain to your web ser

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread S . Isaac Dealey
> Hi > How can I remove UNICODE characters from Coldfusion, is > there a > script/custom tag I can include to ensure that characters > such as > ' " - etc are displayed correctly and not as * * * No guarantees that users won't insert other characters in your forms, but don't use nchar, nvarchar,

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Paul Hastings
> Why shouldnt you need to remove Unicode characters ?? why remove them? there isn't anything "wrong" with unicode chars in a text stream. i use unicode all the time, its our standard. > As you will encounter non-standard characters. The most common example is an accent in someone's name, such as

CF and Sage Data Objects

2004-08-04 Thread Ian Tait
Hi, Anybody got SDO to work with cf, talking to Line 50? Ta, Ian Thoughtbubble Ltd Full Service Agency United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 [Todays Threads] [

CF Poll with Flash interface

2004-08-04 Thread Marco Antonio C. Santos
Do you know any? Maybe open source? Like Christian Cantrell (http://www.markme.com/cantrell/) is the best... ;-) Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Jochem van Dieten
Ian Vaughan wrote: > Ive tried the following at the top of the template, but it still displays the square character on certain characters such as ' " - >   > > ISO-8859-1? You are in the UK but you are trying to use a charset that doesn't even have the euro symbol? Bite the bullet and conve

RE: Interesting Error...

2004-08-04 Thread Tangorre, Michael
The error box did not say what line. All I got was type and message. Check the same topic with the (update) in the subject... Mike > > Anyone seen this? > > TYPE: java.lang.ArrayIndexOutOfBoundsException > > MESSAGE: 6>=6 > > Well, yes. > What is the line of code generating the error ? [Todays

RE: CF Poll with Flash interface

2004-08-04 Thread Robertson-Ravo, Neil (RX)
This is the one which is on the DRK (cant remember which one)    _   From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:12 To: CF-Talk Subject: CF Poll with Flash interface Do you know any? Maybe open source? Like Christian Cantrell (http://www.markme.com/cantre

CFMX and Crystal Reports

2004-08-04 Thread Kristopher Pilles
Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: "#GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt" datasource="waitlist" username="username

Re: CF Poll with Flash interface

2004-08-04 Thread Andy Allan
You can buy DRK5 and get Pollster 2, which is of course what Christian uses. Andy Quoting "Marco Antonio C. Santos" <[EMAIL PROTECTED]>: > Do you know any? Maybe open source? Like Christian Cantrell > (http://www.markme.com/cantrell/) is the best... ;-) > > Thanx > -- [EMAIL PROTECTED] www.c

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
I was only using 'iso-8859-1' as an example (sorry to confuse you!) I used utf-8 in my templates even though that its standard to MX ??? but it some characters are still displaying the square character etc.. From: Jochem van Dieten [mailto:[EMAIL PRO

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Hua Wei
Ian, try on top of your templates Hua -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:26 AM To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters I was only using 'iso-8859-1' as an example (sorry to confuse you!) I used utf-8 in

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
Just tried the following in the page template and the text returned from the database is still like years From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:31 To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters Ian, try on to

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Tait
Hi, As a matter of interest, what encoding do you have your browser set to? Ian -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:34 To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters Just tried the following in the page template a

Re: CFMX and Crystal Reports

2004-08-04 Thread Joe Rinehart
Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.  We pass an authentication id / token over to the ASP pages which then reauth

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Jochem van Dieten
Ian Vaughan wrote: >   >  I used utf-8 in my templates even though that its standard to MX ??? It is, and unless you override it somewhere you shouldn't need to use it. > > The second one is uncessary, the one in the HTTP headers takes precedense. > but it some characters are still displ

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Jochem van Dieten
Ian Vaughan wrote: > Just tried the following in the page template >   > > > >   > and the text returned from the database is still like >   > years In which charset was the data entered in the database and which charset does the database use internally? Could it be that data in the datab

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Hua Wei
Does the data in the database saved in its proper charset?(COLLATE) -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:34 AM To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters Just tried the following in the page template an

RE: Coldfusion & UNICODE Characters

2004-08-04 Thread Ian Vaughan
Jochem Could a filter be run when adding data to the database with Coldfusion to ensure that the correct charset is entered ??? The text looks like the snippet below when on a static webpage "This is a great opportunity" But if I copied the text and pasted it into a html form field for

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Paul Hastings
> It is, and unless you override it somewhere you shouldn't need to > use it. perhaps but its good practice. don't be shy about declaring encoding. > > > > The second one is uncessary, the one in the HTTP headers takes > precedense. yes but there are critters out there that sometimes can't figu

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Paul Hastings
> years "[]" mean the browser can't render that char, "?" mean the text is garbaged. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Gestaltech/Black Knight

2004-08-04 Thread Jim Campbell
Hi - Does anyone know the contact info for Gestaltech?  I'm trying to download the Black Knight trial, but their account registration system's having some problems and I can't find any contact info apart from an info@ email address.  I'd like to get it soon, I'm staring down a proof-of-concept

Re: Trying to uplaod a file using CFFILE, I am getting an error...

2004-08-04 Thread Brian Yager
I believe this was it...Thanks much for the help! Brian >Make sure your filefield attribute is correct in the cffile action.  I >think it needs just the field name 'myfile'  not '#form.myfile#' > >-- >Expert Hosting for Less! >http://exciteworks.com > > > > [Todays Threads] [This Message]

Re: Trying to uplaod a file using CFFILE, I am getting an error...

2004-08-04 Thread Brian Yager
The JS is not altering the file upload...it is just grabing the name of the file and placing it in a hidden form field. Brian >You cannot use JS to alter a file upload field value. This is a security >feature. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

RE: CFMX and Crystal Reports

2004-08-04 Thread Kristopher Pilles
YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some he

RE: tip of the day

2004-08-04 Thread Michael Kear
In SQLServer,  the syntax to get a random record is: SELECT TOP 1 * FROM tablename Order By NEWID() In SQLServer, the NEWID() function gives the random record. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com From: Ewok [mai

Re: Flash Remoting

2004-08-04 Thread Kevin Graeme
It's magic. -Kevin - Original Message - From: "Cutter (CF-Talk)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 04, 2004 7:37 AM Subject: Flash Remoting > Is Flash Remoting automatically loaded with CFMX 6.1? If so, why don't I > have a flashservices/gatew

Re: ListGetAt vs. ListToArray

2004-08-04 Thread Brian Yager
Why not just loop on the list? Brian >I have an application where I have to read a large file, record by record. >After each record is read, I do some processing of the data and then save it >to a database table.  The question is, after I've read the record (which is >a comma separated string) is

Re: Gestaltech/Black Knight

2004-08-04 Thread Tony Weeg
[EMAIL PROTECTED] thats matts email i think? tw On Wed, 04 Aug 2004 08:44:33 -0500, Jim Campbell <[EMAIL PROTECTED]> wrote: > Hi - > > Does anyone know the contact info for Gestaltech?  I'm trying to > download the Black Knight trial, but their account registration system's > having some proble

RE: tip of the day

2004-08-04 Thread Ian Tait
Hi, The only (potential) problem with NEWID is that it does a tablescan, and hence can be very expensive. AFAIK, It only works properly in SQL 2000 too. Ian -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 15:36 To: CF-Talk Subject: RE: tip of

Re: Coldfusion & UNICODE Characters

2004-08-04 Thread Jochem van Dieten
Ian Vaughan wrote: >   > Could a filter be run when adding data to the database with Coldfusion > to ensure that the correct charset is entered ??? I'm sure it is possible, but I have never needed it and I wouldn't know how to write or where to get a filter. > The text looks like the snippet bel

Referencing a query column while still in the query

2004-08-04 Thread James Smith
OK, this time I really am stuck.  I have removed quite a lot from this query to make it easier to read, normally selects more fields and has WHERE, GROUP BY and ORDER BY clauses. SELECT   d.ItemID, d.Title, d.MediaType,  (avg(i.BuyersPrice/i.Quantity) -avg(q.Cost)*1.175  

RE: ListGetAt vs. ListToArray

2004-08-04 Thread Samuel R. Neff
Your primary concern should be normalizing the data.  Issues like this don't come up with normalized data and comma separated lists are an obvious sign of a non-normalized database. Barring that, the speed question comes down to if you're accessing items by index or looping over them.  If looping,

Re: CF Poll with Flash interface

2004-08-04 Thread Christian Cantrell
On Aug 4, 2004, at 9:22 AM, Andy Allan wrote: > You can buy DRK5 and get Pollster 2, which is of course what Christian   > uses. Yup, that's what I use, and it works great.  You can read more about   Pollster 2.0 here: http://www.macromedia.com/software/drk/productinfo/product_overview/ volume5

RE: Referencing a query column while still in the query

2004-08-04 Thread Pascal Peters
You can't do it in CF, you have to do it in SQL. The easiest way would be to create a (SQL) function that returns the proper value depending on the media type. Pascal > -Original Message- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: 04 August 2004 17:02 > To: CF-Talk > Subject: R

Re: Referencing a query column while still in the query

2004-08-04 Thread Ben Doom
No, you can't reference the value of a column while building the query.   The column doesn't *have* a value in it until the query is built, sent, and the results returned. However, you could create a helper table to hold the appropriate information, and grab it that way. Or you could march thr

RE: Referencing a query column while still in the query

2004-08-04 Thread Hugo Ahlenius
to me it seems like there should be a costs table with mediatype and costs columns, and you should join with that. -- Hugo Ahlenius - Hugo Ahlenius  E-Mail: [EMAIL PROTECTED] Project Officer    Phone: 

RE: Referencing a query column while still in the query

2004-08-04 Thread James Smith
> No, you can't reference the value of a column while building > the query. >   The column doesn't *have* a value in it until the query is > built, sent, and the results returned. That is what I figured. > However, you could create a helper table to hold the > appropriate information, and gra

Re: Referencing a query column while still in the query

2004-08-04 Thread Bryan Stevenson
James...you said: No good, already considered this but I need to be able to sort on the final AvgMargin Column so it must have the correct value in to start with. What about a query of a query to get the final sort? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Sys

RE: Referencing a query column while still in the query

2004-08-04 Thread James Smith
I had also considered this but I was just looking for a more "elegant" solution that got the job done in one go.  I am just about to build a new table with mediatype and shippingcosts in it so I can just join them. -- Jay > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTEC

Development of Free Applications

2004-08-04 Thread Peter Farrell
I read the Jim Davis is developing an open source security application and it prompted me into thinking about something I'm doing at the moment. I know there are many well established ListServ type applications already out, but I've not come across any CF based ListServ applications that are open

Re: Referencing a query column while still in the query

2004-08-04 Thread I-Lin Kuo
SELECT   d.ItemID, d.Title, d.MediaType,  (avg(i.BuyersPrice/i.Quantity) -avg(q.Cost)*1.175 -avg(i.BuyersPrice/i.Quantity)*0.15 + CASE mediatype  WHEN 1 then 1.1  when 2 then 1  ...    END AS AvgMargin FROM SomeTables --- James Smith <[EMAIL PROTE

Re: Arabic Text

2004-08-04 Thread Aaron Rouse
I am curious on something regarding Arabic text.  We have a page here that one of the clients enters in data that is Arabic, this inserts fine into the database on CF5 but moving it to CFMX it errors out.  I would have thought it would be the reverse since it was my understanding CFMX was native UT

Re: Flash Remoting

2004-08-04 Thread Dave Carabetta
On Wed, 04 Aug 2004 08:37:11 -0400, Cutter (CF-Talk) <[EMAIL PROTECTED]> wrote: > Is Flash Remoting automatically loaded with CFMX 6.1? If so, why don't I > have a flashservices/gateway folder anywhere? > For ColdFusion, yes it's installed automatically. But you won't find a directory structure.

Re: Referencing a query column while still in the query

2004-08-04 Thread Bryan Stevenson
Goodthat's ultimately the best fix ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]   - Original Message -   From: James Smith   To: CF-Talk   Sent: Wednesday, August 04, 2004 8:32 AM  

SOT: SQL query requires qualified tablename

2004-08-04 Thread Dave Francis
In CF5.0,  SQL 2k For some reason, tables in one of my databases require a qualified name to work, ie.     this works fine:     SELECT * FROM dsnabc.dbo.tblxxx     this fails:     SELECT * FROM tblxxx     with:     ODBC Error Code S0002 (Base table not found)   

Re: Interesting Error...

2004-08-04 Thread Steve Dworman
are you running mssql server? this might be what you need http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_cpu.htm >Anyone seen this? > >TYPE: java.lang.ArrayIndexOutOfBoundsException >MESSAGE: 6>=6 > >Just started popping up... > >Mike [Todays Threads] [This Mes

Re: What is that *.XML configuration file for?

2004-08-04 Thread Troy Simpson
What config file is used to manage the Internal Web Server (JWS) that comes with JRun? Troy Dave Watts wrote: > > What is the web.xml configuration file for? > > It's used to specify configuration for your Java web application. There's > actually a decent explanation here: > http://www.macromed

OT: Flash Datagrid

2004-08-04 Thread DURETTE, STEVEN J (AIT)
Hi all, I have an OT question about Flash Datagrids (Flash MX 2004 Pro 7.2).  I used Ben Forta's article on using datagrids in Flash (http://www.macromedia.com/devnet/mx/coldfusion/articles/dc_wizard.html ) and I have everything set up. What I would like to be able to do is when the user cl

remote restart cfmx service

2004-08-04 Thread Tony Weeg
does anyone have a quick and easy way to set something up that could kickstart a cfmx service if it were hung, etc? from? 1. a web page 2. an sms message to an email reader to an application 3. any other ideas, insert here :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog:

Re: What is that *.XML configuration file for?

2004-08-04 Thread Dave Carabetta
On Wed, 04 Aug 2004 12:44:41 -0400, Troy Simpson <[EMAIL PROTECTED]> wrote: > What config file is used to manage the Internal Web Server (JWS) that > comes with JRun? > That's in your SERVER-INF/jrun.xml file. Towards the very bottom of the file, you will see entries for the JWS: ... The exte

Datatype Mismatch Error on Update - Help!

2004-08-04 Thread hammerin hankster
I've got a strange problem. Whenever I try to add more than 13 fields, I get a "datatype mismatch error".  Below is my update query: UPDATE tblbillingaddr SET billingcontact = '#Form.billingcontact#', billingemail = '#Form.billingemail#', billingaddr = '#Form.billingaddr#', billingaddr2 = '#For

RE: Datatype Mismatch Error on Update - Help!

2004-08-04 Thread Burns, John D
Do you have any kind of limit set in your datasource settings in regards to buffers or anything like that?  Are any of the fields you're using exceptionally long? (Textarea boxes?)  That's all I can think of to suggest. John -Original Message- From: hammerin hankster [mailto:[EMAIL PROTE

XML and Databases

2004-08-04 Thread Chad McCue
this is my code       #session.FieldStructure["CompanyName"]#    #session.FieldStructure["Title"]#    #session.FieldStructure["LogoImage"]#    #session.FieldStructure["EmailAddress"]#    #session.FieldStructure["WebAddress"]#    #session.FieldStructure["Comments"]#             #session.FieldStruc

Re: XML and Databases

2004-08-04 Thread Barney Boisvert
Sure, one of the benefits of XML is that its plain text, so you can store it just like any other text string, including in a database. cheers, barneyb On Wed, 4 Aug 2004 13:40:10 -0400, Chad McCue <[EMAIL PROTECTED]> wrote: > this is my code > > >   >   #session.FieldStructure["CompanyName"]# >

Re: remote restart cfmx service

2004-08-04 Thread lists
Running CFMX on JRun?  You can use the JMC to bounce CFMX.  I suppose many have the JRun Admin server off for security maybe.  So, how does the JMC restart a server?  Does it maybe use some sort of Java class that is exposed to CF?   Also, could use ASP to exec a bat file, eh?   -- --- Douglas K

Re: XML and Databases

2004-08-04 Thread Chad McCue
I saved it in my database as ToString(TemplateFields) How can I apply XML functions to this when I read it from the DB? When I try to do a XxlParse(fieldname) I get an error.   - Original Message -   From: Barney Boisvert   To: CF-Talk   Sent: Wednesday, August 04, 2004 1:46 PM   Subjec

get refering url

2004-08-04 Thread chad gray
cgi.HTTP_REFERER does not seem to pick up domain names outside of the web site it runs from. I.E. if somone comes from google.com to my web site i cannot use cgi.HTTP_REFERER to find out where they came from.  The variable is blank.  I was hoping is would be google.com. Anyone know of a way to ge

Re: XML and Databases

2004-08-04 Thread Joe Rinehart
Chad, Sure istoString(templateXml) will turn your xml document into its string equivalent.  You can then store it in any database field of an appropriate type (ntext, etc).  Reading it back out, just use xmlParse() to turn it back into an xml document. Have a good one, Joe - Original Me

Re: SOT: SQL query requires qualified tablename

2004-08-04 Thread Ben Doom
It sounds like the user for that DSN doesn't have that DB assigned as its default. Just an idea. --Ben Dave Francis wrote: > In CF5.0,  SQL 2k > > For some reason, tables in one of my databases require a qualified name > to work, ie. >    > this works fine: >  > SELECT * FROM ds

Re: XML and Databases

2004-08-04 Thread Joe Rinehart
Chad, What error are you getting? -joe - Original Message - From: Chad McCue <[EMAIL PROTECTED]> Date: Wed, 4 Aug 2004 13:57:56 -0400 Subject: Re: XML and Databases To: CF-Talk <[EMAIL PROTECTED]> I saved it in my database as ToString(TemplateFields) How can I apply XML functions to t

RE: get refering url

2004-08-04 Thread Burns, John D
Many firewalls and things of that nature strip this variable out.  It should work for a lot of people but not all. John -Original Message- From: chad gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 2:00 PM To: CF-Talk Subject: get refering url cgi.HTTP_REFERER does not

Re: XML and Databases

2004-08-04 Thread Barney Boisvert
Are you trying xmlParse within the CFQUERY tag?  xmlParse is a CF function, not a SQL function, so you need to do it in your CF code: ...   INSERT INTO myTable     (xmlCol)   VALUES     ('#toString(tempxml)#') -- use CFQUERYPARAM   SELECT xmlCol   FROM myTable cheers, barneyb On Wed, 4 Au

Re: remote restart cfmx service

2004-08-04 Thread Dick Applebaum
You could set up a VPN on the target server. I have used a similar setup to install, update, start, restart CFMX. You can even reboot the target server -- but need to wait for the VPN service to restart & relogin. I don't know about win, but VPN is pre-installed with OS X and  (I think) with L

Re: Arabic Text

2004-08-04 Thread Qasim Rasheed
Aaron, How are you handling insertion of data into database with Arabic text on CF5. I mean which dbms, odbc driver etc? Thanks Qasim - Original Message - From: Aaron Rouse <[EMAIL PROTECTED]> Date: Wed, 4 Aug 2004 10:43:13 -0500 Subject: Re: Arabic Text To: CF-Talk <[EMAIL PROTECTED]>

isDefined Equivalent for an Array

2004-08-04 Thread Larry Lyons
Its a long hot afternoon and my brain feels blocked, so pardon the stupid question, but is there an equivalent of isDefined for Arrays? many thanks, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Arabic Text

2004-08-04 Thread Qasim Rasheed
yes I am pretty sure about it. The Arabic text in my SQL Server is display correctly whose datatype is ntext but somehow when the records are returned from database for CF5 its all ??. Any thoughts? Qasim - Original Message - From: Paul Hastings <[EMAIL PROTECTED]> Date: Wed, 4 Aug 2004 0

Re: Arabic Text

2004-08-04 Thread Aaron Rouse
It is a Oracle 9i database, I do not have access to the administration of the boxes but I would assume it is using ODBC connections on the CF end and just the default drivers from the instalation. On Wed, 4 Aug 2004 14:30:43 -0400, Qasim Rasheed <[EMAIL PROTECTED]> wrote: > Aaron, > > How are you

Re: isDefined Equivalent for an Array

2004-08-04 Thread Barney Boisvert
As in "test for the existance of a certain index"?  Not built-in, but I believe I've seen a UDF that'll do it floating around.  Pretty simple, just try and dereference the index, and catch an exception. if it's ok, return true, if error, return false. cheers, barneyb On Wed, 04 Aug 2004 14:33:05

Re: CF Poll with Flash interface

2004-08-04 Thread Marco Antonio C. Santos
Thanx all... Pollster 2 is very very nice... Marco On Wed, 4 Aug 2004 11:01:57 -0400, Christian Cantrell <[EMAIL PROTECTED]> wrote: > On Aug 4, 2004, at 9:22 AM, Andy Allan wrote: > > > You can buy DRK5 and get Pollster 2, which is of course what Christian > > uses. > > Yup, that's what I use

Re: isDefined Equivalent for an Array

2004-08-04 Thread Michael A Vinson
IsArray(value, [number]) -helps to keep that biggole CF poster tacked on the wall :) -mike Larry Lyons <[EMAIL PROTECTED]> 08/04/2004 02:33 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:isDefined Equivalent for an Array Its a lo

Re: isDefined Equivalent for an Array

2004-08-04 Thread Raymond Camden
Um, no. The second attribute to isArray checks to see if the variable is an array in that particular dimension. There is no built-in way to see if an array element is defined. You can , however, use a simple UDF. CFLib has one. On Wed, 4 Aug 2004 14:39:38 -0400, Michael A Vinson <[EMAIL PROTECTED]

Re: isDefined Equivalent for an Array

2004-08-04 Thread Kevin Graeme
Poster? Where can I get one? -Kevin - Original Message - From: "Michael A Vinson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 04, 2004 1:39 PM Subject: Re: isDefined Equivalent for an Array > IsArray(value, [number]) > -helps to keep that biggole CF pos

Re: isDefined Equivalent for an Array

2004-08-04 Thread Runar Petursson
what about using: test_index lte arraylen(myarray) - Original Message - From: Raymond Camden <[EMAIL PROTECTED]> Date: Wed, 4 Aug 2004 13:42:39 -0500 Subject: Re: isDefined Equivalent for an Array To: CF-Talk <[EMAIL PROTECTED]> Um, no. The second attribute to isArray checks to see if th

Re: isDefined Equivalent for an Array

2004-08-04 Thread Barney Boisvert
CF arrays aren't necessarily filled to the final element.  For example, take this code: a = arrayNew(1); a[2] = "test"; temp = a[1]; dereferencing index 1 in the third line with throw an exception, becuase it was never initialized, even though you initialized a larger index. cheers, barneyb On

Re: Arabic Text

2004-08-04 Thread Claude Schneegans
>>How are you handling insertion of data into database with Arabic text on CF5. I mean which dbms, odbc driver etc? If the arabic text is coded in any coding system, uncluding UTF-8, it is still plain ASCII, so it can fit in any database, even dBase. The only things that may cause trouble are alph

Re: Arabic Text

2004-08-04 Thread Aaron Rouse
That makes sense, so what should be done on CFMX in order for it to insert?  I know there is the checkbox in the admin for UTF8 which we did have verified was checked, but I am guessing there is something else we have over looked. On Wed, 04 Aug 2004 15:14:20 -0400, Claude Schneegans <[EMAIL PROTE

Re: Image Manipulation - server side

2004-08-04 Thread Ray Champagne
Thanks to everyone that added in their comments and solutions.  I went with the cfx_image solution, as it was free, and for a free tag, was quite powerful!  There are a lot of things that tag can do that I was completely unaware of. Qasim, I definitely want to take a look at your solution once

Off topic SQL question from a novice

2004-08-04 Thread John Munyan
Hi, I have 2 tables - the hike table which contains all the per hike data.  The second table is a user review table which is assoicated with the Hike table by HikeID. At any rate. I use a sql query to generate the left nav.  It is similiar to select HikeName, HikeID, HikeDate, HikeStars from

Re: tip of the day

2004-08-04 Thread daniel kessler
So by caching the query, it assures that everyone gets the same random TIP for the day or just that particular machine? > well there are a couple of ways to get a random record... > as long as ou are not using access there is a RAND() function to do it... > > something like this if i remember cor

Re: remote restart cfmx service

2004-08-04 Thread Tony Weeg
by VPN, you mean Virtual Private Network? or do you mean something else? tw -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Su

Re: Off topic SQL question from a novice

2004-08-04 Thread Jeff Congdon
i'm guessing your "reivew" table schema, so change the B.* names accordingly: select a.HikeName, a.HikeID, a.HikeDate, a.HikeStars, COUNT(b.hikeid) from Hike A INNER JOIN HikeReview B ON A.hikid = B.hikeID group by a.hikename, a.hikeid, a.hikedate, a.hikestars order by HikeDate Desc John

  1   2   >