RE: does cf choke on database nulls?

2004-05-10 Thread John Beynon
You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:13 To: CF-Talk Subject: does cf choke on database nulls? select sum(stopTime) from reports where vehicleNumberoni = 58444 return

RE: Microsoft acknowledges CF!

2004-05-10 Thread Raymond Camden
You know, I'm probably biased, but you have to love the fact that almost every code comparison shows CF having about half the lines .Net does. I like .Net, a lot, and yes, we all know the # of lines isn't the most important thing in the world, but it was funny how much this stood out, especially in

RE: does cf choke on database nulls?

2004-05-10 Thread John Beynon
Duh! Ignore me...more coffee! -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:11 To: CF-Talk Subject: RE: does cf choke on database nulls? You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: To

Re: JVM settings for OS X - was: Re: Blue Dragon / Coral / CFMX

2004-05-10 Thread Matt Liotta
In the JMC, you need to change the JDK path to   /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home. Matt Liotta R337 Consulting LLC http://r337.com On May 10, 2004, at 7:46 AM, Dick Applebaum wrote: > Matt > >  With my changes to your startup script I get the following results: > >

RE: does cf choke on database nulls?

2004-05-10 Thread Tony Weeg
that isnt ... altho' that wont return anything to cf either, however... the problem, I found out, is that there was a value in one of the fields that was longer than 9 characters, its actually 10 characters, numbers I mean and therefore a sum() on that doesn't jive, in query analyzer or cfmx. make

RE: does cf choke on database nulls?

2004-05-10 Thread Tony Weeg
its all good man! thanks anyway. tw -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:14 AM To: CF-Talk Subject: RE: does cf choke on database nulls? Duh! Ignore me...more coffee! -Original Message- From: John Beynon [mailto:[EMAIL PRO

Re: does cf choke on database nulls?

2004-05-10 Thread Dick Applebaum
Looks like a driver error. Interesting that I am having a null problem in CFML (not the driver) with BlueDragon. I have been on this list for years and don't recall any posts where DB nulls were improperly handled by a driver or CFML.  (there have been issues with how to logically handle nulls

RE: does cf choke on database nulls?

2004-05-10 Thread Tony Weeg
dick, I happened to figure out that it wasn't a null issue tho' :) that's good! not for your problem tho. but, what I did figure out, is that I had bad data coming from the db, and the db wouldn't do the sum(), that was the problem.  cfmx handled it great, from what I can tell. so what Ive don

Re: Microsoft acknowledges CF!

2004-05-10 Thread Pete Ruckelshaus - CFList
The one thing that still sticks out to me (I went from ASP to CF almost 5 years ago) is just how much more difficult database interaction is when you're not using CF.  I also explicitly DON'T like the presentation layer control that the display objects take away; that's fine if you're a develop

RE: Microsoft acknowledges CF!

2004-05-10 Thread Steve Nelson
Boy isn't that the truth! They also only talked about the general functionality of CF. There are so many built in functions in CF that I think we all take for granted because they've been in there so long. Things like manipulating lists, queries, dates, display formatting. The list of CF's *real

homesite+ (how to stop a find search)

2004-05-10 Thread Tony Weeg
hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?  lets say it locates what I wanted it to find for me, how do I say STOP, Look no more.  I restart homesite+ now to do this, is there a better way? thanks! ...tony tony weeg senior web applica

Re: JVM settings for OS X - was: Re: Blue Dragon / Coral / CFMX

2004-05-10 Thread Dick Applebaum
Aha! That does it -- setting the JVM in the JMC, along with your startup script, gets both JRun and CFMX running under the latest JVM. What is odd, is that JRun and CFMX can't do this automatically  -- OS X will default to the latest JVM unless the applications (JRun and CFMX) specifically req

re: homesite+ (how to stop a find search)

2004-05-10 Thread Scott Brady
I haven't tried this in Homesite+, but in Homesite and CF Studio, hitting ESC usually does it. Scott --- Scott Brady http://www.scottbrady.net/ Original Message: > From: "Tony Weeg" > Date: Mon, 10 May 2004 09:38:47 -0400 > hi there. > > really a homesite+ question, bu

RE: homesite+ (how to stop a find search)

2004-05-10 Thread Tony Weeg
works GREAT! thanks. tony -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:43 AM To: CF-Talk Subject: re: homesite+ (how to stop a find search) I haven't tried this in Homesite+, but in Homesite and CF Studio, hitting ESC usually does it. Sco

RE: homesite+ (how to stop a find search)

2004-05-10 Thread Steve Nelson
Press the ESC key. Steve Nelson   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:39 AM To: CF-Talk Subject: homesite+ (how to stop a find search) hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?  lets say i

Re: Microsoft acknowledges CF!

2004-05-10 Thread Dick Applebaum
I have done some ASP coding -- mainly converting programs to CF. Not only is a lot more work (in ASP) to put together a SQL query, there are a lot of things to keep track of -- if you forget to close the connection it can affect performance, etc, Number of lines is not everything -- but a more

RE: Microsoft acknowledges CF!

2004-05-10 Thread Benjamin S. Rogers
> They also only talked about the general functionality of CF. There are so > many built in functions in CF that I think we all take for granted because > they've been in there so long. Things like manipulating lists, queries, > dates, display formatting. The list of CF's *real development benefits

RE: Microsoft acknowledges CF!

2004-05-10 Thread Tom Kitta
What do you mean by shallow support? Honestly I almost never used Java in CF since CF has almost everything I ever needed. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. The specialization of a langua

RE: Microsoft acknowledges CF!

2004-05-10 Thread Bernd VanSkiver
One thing nice about the .NET Framework is that if an application is designed well it is easy (fairly) to make it available in many formats (web site, windows app, pocket pc app), I think that is one of the reasons it is built like it is.  It is nice to have that ability to port the software to dif

RE: Microsoft acknowledges CF!

2004-05-10 Thread Tom Kitta
Is there a way to use CF code outside of a server, stand alone executable (without any server like software including that mini server offered for presentation purposes)? In other words can I "compile" a cf page and save it in cgi directory? I am just curious since now CF page is compiled before it

RE: Microsoft acknowledges CF!

2004-05-10 Thread Philip Arnold
> From: Tom Kitta > > Is there a way to use CF code outside of a server, stand > alone executable (without any server like software including > that mini server offered for presentation purposes)? In other > words can I "compile" a cf page and save it in cgi directory? > I am just curious sinc

Re: Microsoft acknowledges CF!

2004-05-10 Thread Bob Ries
Ignore... just a subscription test msg.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Web services that return/set multiple variables.

2004-05-10 Thread Craig Dudley
Update, >From searching google for a couple of hours, the only suggested answer I've seen is to write a .NET webservice and use that as a proxy, anybody got a better idea or workaround? To be honest CF's ws stuff appears to be about as compatible with other scripting languages as a large squ

Search solution.

2004-05-10 Thread Bailey, Neal
Hey guys I want to set up a search on my personal site for my products. I have tried to use the verity collection but it just does not seem to do what I want. I need something that can simply spider my site and collect the information and links to the products. The site is very dynamic and

Stand alone CF application on a laptop

2004-05-10 Thread Wurst, Keith D.
hey everyone. i would like to setup a cf application on a laptop running sql server as the backend db and iis as the webserver. does anyknow know of a good resource that laysout how to set this type of environment up? is there a copy of a personal cf application server out there for download? thank

RE: Stand alone CF application on a laptop

2004-05-10 Thread Ian Skinner
The 30 day free trial version of CF server reverts to a local host only developers version after the trial period.  It would be exactly what you want. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!"  - Cynt

RE: Stand alone CF application on a laptop

2004-05-10 Thread Wurst, Keith D.
Looks like that is for MX, is there one for cf 5? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:57 AM To: CF-Talk Subject: RE: Stand alone CF application on a laptop The 30 day free trial version of CF server reverts to a local host only dev

RE: Stand alone CF application on a laptop

2004-05-10 Thread Ian Skinner
This is how it has worked since at least 4.5.  It is how I have gotten my developer version of CF sever since I started in 1997.  You just need to find the proper download on the Macromedia Site.  That, at times, has been a lot harder then it should have been. -- Ian Skinner Web Program

RE: schedule admin and SSL

2004-05-10 Thread Whittingham, P
Hi,   Here is more information from the application log. This job is setup as https://cfm and port = 443 in cfadmin. This is on w2k server and cf is assigned to the system account. The entire web server has a certificate, so i guess everything must use 'https' "aaa web server name",ap

CFMX 6.1 and Order By Error

2004-05-10 Thread Eric Davis
I'm having a very strange problem with CFMX. I'm creating a very simply query. debug> SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName However, when I add more than one field

Flash & Speed?

2004-05-10 Thread Adkins, Randy
I know you can determine if someone has Flash installed. Is there anyway to determine the speed of the connection, where it is Dial-up? DSL? LAN? Basically I need to find out if their speed is fast enough to use Flash or Static images. TIA [Todays Threads] [This Message] [Subscription] [Fa

RE: XMLParse() Throwing Error - Shared Hosting

2004-05-10 Thread Barney Boisvert
You can just call listRest twice (or use listDeleteAt() if you prefer), passing chr(10) as the delimiter.  Exactly the same thing as you do, just minus the array conversions. Cheers, barneyb > -Original Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 09,

Re: Flash & Speed?

2004-05-10 Thread Dick Applebaum
Give the user the option! HTH Dick On May 10, 2004, at 9:15 AM, Adkins, Randy wrote: > I know you can determine if someone has Flash installed. >  Is there anyway to determine the speed of the connection, where >  it is Dial-up? DSL? LAN? > >  Basically I need to find out if their speed is fast

RE: Flash & Speed?

2004-05-10 Thread Adkins, Randy
Yeah that was the only option I came up with. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:37 PM To: CF-Talk Subject: Re: Flash & Speed? Give the user the option! HTH Dick On May 10, 2004, at 9:15 AM, Adkins, Randy wrote: > I know yo

RE: schedule admin and SSL

2004-05-10 Thread Dave Watts
>   Here is more information from the application log. This job > is setup as https://cfm and port = 443 in cfadmin. This > is on w2k server and cf is assigned to the system account. > The entire web server has a certificate, so i guess > everything must use 'https' >   > "aaa web serve

Client Variables not written to database

2004-05-10 Thread Scott Brady
We're starting the process of upgrading our server from CF5 to MX 6.1 and am running into problems with client variables not "sticking". We are storing client variables in an Oracle database.  I have a test script which first dumps the client variables, then sets a test client variable, and then d

Re: Flash & Speed?

2004-05-10 Thread Bryan Stevenson
Yep...go with allowing the user to chose. I just went through browser detection scenarios for a site we just launched and chose to warn users with browsers we have not yet tested (although they use browser engines that are used in browsers we've tested).  We simply re-direct them to a warning page

RE: Flash & Speed?

2004-05-10 Thread Barney Boisvert
You can load a flash movie, start a timer in the movie, load an image from your server, check how long it took, and then decided based on that. 'course that's probably not really how you want to approach the situation, but it'll work. Cheers, barneyb > -Original Message- > From: Adkins,

Re: Named anchor

2004-05-10 Thread Christian Cantrell
On May 10, 2004, at 7:37 AM, Pascal Peters wrote: > Is it possible to find a named anchor passed in the url (if there is >  one) in ColdFusion? I don't think there is a way.  The named anchor (anything after the hash symbol in a URL) does not get sent to the server, and therefore does not show

Re: CFMAIL 6.1 ARRGH!

2004-05-10 Thread Jason Fish
Does anybody know if the hot fix for this problem is out yet? If so where can I find it at. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Microsoft acknowledges CF!

2004-05-10 Thread Steve Nelson
I think you can do this a few different ways, but essentially you still need a local application server to execute the pages. With CFMX you could use the developer copy which I think is free for localhost usage. BD offers a free version that I think is only CF5 compatible. Maybe I'm wrong. Coral

RE: CFMX 6.1 and Order By Error

2004-05-10 Thread Steve Nelson
It's hard to tell from the line wrapping, but it looks like you're trying to do a union of two selects, but you left out the union operator. Is that what you're doing? Also, try removing the table names from the order by clause. Steve Nelson   _   From: Eric Davis [mailto:[EMAIL PROTECTED]

CFTicket 2 released

2004-05-10 Thread Cedric Villat
Just wanted to let everyone know that we have released CFTicket 2. I want to thank everyone on the list who helped us out in the beta testing. Because of all the great people, I am giving 20% off the current price as a thank you to everyone here. You can get more details at http://www.cornfeed.com

RE: Microsoft acknowledges CF!

2004-05-10 Thread Benjamin S. Rogers
> What do you mean by shallow support? There's a good deal of Java that simply can't be used directly from within CF. A lack of support for null values is a big reason. There's also a good deal that requires workarounds or hacks. It's certainly possible to use a lot of Java from within CF, but it

Re: CFMX 6.1 and Order By Error

2004-05-10 Thread Deanna Schneider
"section" is a reserved word. That bit us recently. Is that the column that kills it? -d - Original Message - From: "Eric Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 11:14 AM Subject: CFMX 6.1 and Order By Error > I'm having a very strange prob

Re: CFMX 6.1 and Order By Error

2004-05-10 Thread Kevin Graeme
Adding to that, in that case it was specifically in a QueryOfQuery and referencing "section" as "[section]" made it work. -Kevin - Original Message - From: "Deanna Schneider" > "section" is a reserved word. That bit us recently. Is that the column that > kills it? > -d [Todays Threads]

Namespaces in XMLParse() file...

2004-05-10 Thread Tyler Silcox
Are there any tricks to get CFMX to parse a XML file with referenced or unreferenced namespaces in them? I have a XML file that I can read just fine, but when I try to run a XMLParse() on the variable, it throws me a NAMESPACE_ERR error. And if I take out the tag with the namespace in it, it wor

RE: Namespaces in XMLParse() file...

2004-05-10 Thread Tyler Silcox
As usual, I figured out part of this right after I hit sent on my message:       If I add the namespace declaration to the root element, it won't throw an error.   I know it is not quite proper, but is there a way to get around declaring the namespace in the root element? I'd

RE: Namespaces in XMLParse() file...

2004-05-10 Thread Barney Boisvert
Namespaces apply to the current tag, and all decendants, you the tag that declares the namespace can be from that namespace: XML is stringent about single root elements, and since CF's implementation adheres, it won't let you have multiple ones.  However, if you need to add it dynamically, i

CF sending data to a local printer?

2004-05-10 Thread Daniel Farmer
It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscri

Re: CF sending data to a local printer?

2004-05-10 Thread Pete Ruckelshaus - CFList
This is not possible unless you use ActiveX or a client side Java applet.  Trust me.  We tried.  The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to cli

Re: CF sending data to a local printer?

2004-05-10 Thread Charlie Griefer
in IE you can bypass the printer dialogue box without ActiveX or client side Java applet...
    function noDialog (numcopy) {
var i = 1;
for (i; i==numcopy; i++) {
if ((navigator.appName == "Netscape")) {
    window.print()
 

RE: CF sending data to a local printer?

2004-05-10 Thread Philip Arnold
> From: Daniel Farmer > > It's been requested that I create this form that when gets > submitted sends the content to a printer ( in the persons > place of business ). > > I've never done anything like that before. Was wondering if > it was even possible. Because it's on the client's machine

Re: CF sending data to a local printer?

2004-05-10 Thread Daniel Farmer
You mean an applet that is always on, always running right? and checks for print alerts?   - Original Message -   From: Pete Ruckelshaus - CFList   To: CF-Talk   Sent: Monday, May 10, 2004 2:24 PM   Subject: Re: CF sending data to a local printer?   This is not possible unless you use A

Re: CF sending data to a local printer?

2004-05-10 Thread Pete Ruckelshaus - CFList
Yes, the page to be printed would contain this applet.  We are using this method for one of our applications. Pete Daniel Farmer wrote: > You mean an applet that is always on, always running right? and checks for print alerts? >   - Original Message - >   From: Pete Ruckelshaus - CFList

Re: CF sending data to a local printer?

2004-05-10 Thread Gonzo Rock
My guess here is that you envision someone on the internet is browsing a web site and fills out a form. You want that form to print on the web site owners printer? I think that's a WILD idea... however it is only possible if the CF server has network access to the printer.  Is the CF server in

Error with CFINPUT

2004-05-10 Thread Dan Phillips
Hi gang, I have a form using the 'required' attribute of CFINPUT for form validation. It works on one server but not another. By not working, I mean it does not prompt the user to fill out a field. Both servers are running 6.0. Any ideas? Dan Phillips CFXHosting.com [EMAIL PROTECTED] [Todays

RE: Error with CFINPUT

2004-05-10 Thread Marlon Moyer
Does the 2nd site have the CFIDE mapping in IIS?  If not, the cfform.js script will not be loaded and the validation won't take place. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com >

Re: CF sending data to a local printer?

2004-05-10 Thread Daniel Farmer
The question is though is how does that applet see the printer ?   - Original Message -   From: Pete Ruckelshaus - CFList   To: CF-Talk   Sent: Monday, May 10, 2004 3:01 PM   Subject: Re: CF sending data to a local printer?   Yes, the page to be printed would contain this applet.  We a

RE: Error with CFINPUT

2004-05-10 Thread Dan Phillips
Thanks Marlon. That did it! -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 3:09 PM To: CF-Talk Subject: RE: Error with CFINPUT Does the 2nd site have the CFIDE mapping in IIS?  If not, the cfform.js script will not be loaded and the validatio

BlogMX.zip

2004-05-10 Thread Nikhil Madani
Benorama site seems to down most of the time. Can someone please send me the example BlogMX.zip file offlist. TIA Nikhil [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

COM and WDDX

2004-05-10 Thread Brook Davies
Hi Folks, I recently outsourced a project to some developers and am having some issues and would appreciate any advice you may be able to offer. Basically they were contracted to develop a client side app (Written in Delphi) that would connect to a CFMX webservice and download recordset data. T

COM and WDDX

2004-05-10 Thread Brook Davies
Hi Folks, I recently outsourced a project to some developers and am having some issues and would appreciate any advice you may be able to offer. Basically they were contracted to develop a client side app (Written in Delphi) that would connect to a CFMX webservice and download recordset data. T

RE: Namespaces in XMLParse() file...

2004-05-10 Thread Tyler Silcox
Thanks Barney, that all makes total sense.  The whole issue of namespaces in XML has been iffy for me for a little while...mainly, because the URI doesn't really mean anything.  But this time, my fault was that I wasn't thinking about descendents. I'm going to working with a fixed root element 1

CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread coldfusion . developer
I Does anyone know anything about this error.  I can't figure it out.  Here's my code. Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory #shortdesc# #longdesc# #pic# #manf# #p

Re: CF sending data to a local printer?

2004-05-10 Thread Daniel Farmer
Pete - could you describe this applet/process in a bit more detail?   - Original Message -   From: Pete Ruckelshaus - CFList   To: CF-Talk   Sent: Monday, May 10, 2004 3:01 PM   Subject: Re: CF sending data to a local printer?   Yes, the page to be printed would contain this applet.  W

Re: CF sending data to a local printer?

2004-05-10 Thread Daniel Farmer
This is great and will keep for future reference, but I need to print on a printer that is at my client's business. The client won't be printing this.   - Original Message -   From: Charlie Griefer   To: CF-Talk   Sent: Monday, May 10, 2004 2:42 PM   Subject: Re: CF sending data to a loc

Re: COM and WDDX

2004-05-10 Thread Adrocknaphobia
Hrmmm... that quiet intresting. Have you tried using the COM object yourself to confirm what they are saying? I'm a bit suprised that openwddx can't handle a recordset larger that a couple hundred records. -Adam > -Original Message- > From: Brook Davies [mailto:[EMAIL PROTECTED] > Sent: M

RE: CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread Barney Boisvert
Check this line (just inside the inner CFOUTPUT):    Probably want this or something like it: Cheers, barneyb > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, May 10, 2004 1:39 PM > To: CF-Talk > Subject: CFC 2 XML - ERROR: Whitespace requi

RE: CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread Ben Densmore
If you are going to have attributes in your XML they have to be like:   #shortdesc# Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:39 PM To: CF-Talk Subject: CFC 2 XML - ERROR: Whitespace required before attributes I Does any

WDDX, CFMX, and NULLs

2004-05-10 Thread Scott Brady
I managed to figure out how to fix our client variable problem with MX/Oracle (we're going to have to drop and rebuild the cdata and cglobal tables in the database), but am running into WDDX problems for converting from CF5 to MX6.1 and, again, can't find anything online. So, here's our issue. We

Re: CFMX 6.1 and Order By Error

2004-05-10 Thread Eric Davis
Yep.  I noticed when I took out 'section' the query worked just fine. Any idea what the keyword 'Section' relates to in either CF or SQL? -e >>> [EMAIL PROTECTED] 5/10/04 10:51:10 AM >>> "section" is a reserved word. That bit us recently. Is that the column that kills it? -d - Original Messa

Re: CFMX 6.1 and Order By Error

2004-05-10 Thread Eric Davis
Thanks for the additional info.  I tried the square brackets, and they work for straight database queries as well.   -Eric >>> [EMAIL PROTECTED] 5/10/04 11:00:23 AM >>> Adding to that, in that case it was specifically in a QueryOfQuery and referencing "section" as "[section]" made it work. -Kevin

RE: WDDX, CFMX, and NULLs

2004-05-10 Thread Barney Boisvert
WDDX changed between CF5 and CFMX.  Bottom line, CF5 WDDX and CFMX WDDX are incompatible.  They might be really similar, but they're different enough to pretty much break everything.  I think you're going to have to change your code throughout, or perhaps write a custom serialization routine that m

previous next alphabetical

2004-05-10 Thread Emmet McGovern
What's the best way to do a prev - next records output using the alphabet instead of page numbers? Thanks. Emmet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: WDDX, CFMX, and NULLs

2004-05-10 Thread Scott Brady
Original Message: > From: "Barney Boisvert" > WDDX changed between CF5 and CFMX.  Bottom line, CF5 WDDX and CFMX WDDX are > incompatible.  They might be really similar, but they're different enough to > pretty much break everything.  I think you're going to have to change your > code throughout,

re: previous next alphabetical

2004-05-10 Thread Scott Brady
Original Message: > From: "Emmet McGovern" > What's the best way to do a prev - next records output using the > alphabet instead of page numbers? I'd probably use the ASCII values of the letters to easily move up/down the alphabet. Scott --- Scott Brady http://www.scottb

Re: CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread coldfusion . developer
I've tried all these suggestions and here's what the code look like now. NEW ERROR: Illegal character or entity reference syntax.   Illegal character or entity reference syntax.      The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 : #MotorSport

CFC 2 XML - ERROR: Illegal character or entity reference syntax.

2004-05-10 Thread coldfusion . developer
Help, Now I get this error.  Code is listed after code.  Ahh! ERROR: Illegal character or entity reference syntax.   Illegal character or entity reference syntax.   The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 : #MotorSportsFlag# 22 :

RE: CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread Barney Boisvert
Use xmlFormat() around all those variables to escape any legal chars. Cheers, barneyb > -Original Message- > From: [EMAIL PROTECTED] > [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, May 10, 2004 2:37 PM > To: CF-Talk > Subject: Re: CFC 2 XML - ERROR: Whitespace required be

Re: COM and WDDX

2004-05-10 Thread Dick Applebaum
Brook In the past, I have often used WDDX to exchange large recordsets   (thousands of records) between remote hosts.  It becomes somewhat slow   with large recordsets because WDDX is quite verbose.  (e.g. moving a 33   million character Access db to SQL-Server, then moving that to another   remot

Re: previous next alphabetical

2004-05-10 Thread Dick Applebaum
I would convert the first letter of each record control field (the alphabetic field) to upper case. Then I would group by first letter -- throwing all non- A-Z records into a separate group (or bunched in with the As). You can even do groups of groups, eg A-C D-G H-K etc. HTH Dick On May

Re: COM and WDDX

2004-05-10 Thread Brook Davies
Thanks Dick for your reply. At this point we need to get the app out the door, at least version 1. I am also surprised it can't handle a couple of hundred records. The average recordset size will likely be about 100 and could range to 5000, but not very often, so although WDDX adds the extra we

CFMAILPART wrap attribute

2004-05-10 Thread Barney Boisvert
Here's a snip from a plain text message that is sent with CFMAILPART's wrap attribute set to 72: -- The level was changed by Barney Boisvert (userID: 4985) You are being sent this notice because you are the registered site administrator on the site. -- In addition to the paragraph break, there

Re: COM and WDDX

2004-05-10 Thread Dick Applebaum
Well, if that doesn't fix the problem and the alternative is to custom rewrite the WDDX_COM, then have a look at thinArrays. The source is available at: http://rohanclan.com/products/neuromancer/ this includes: --The CFCs to do recordset (query, array) thinArray conversion --Robs Neuromancer _

RE: QofQ with Like returns nullnull error

2004-05-10 Thread J E VanOver
Sorry, I don't think you can use "LIKE" on QofQ I couldn't find any citations to confirm it.  Anyone care to contradict me? J   -Original Message-   From: Deanna Schneider [mailto:[EMAIL PROTECTED]   Sent: Monday, May 03, 2004 11:28 AM   To: CF-Talk   Subject: QofQ with Like returns nulln

Re: COM and WDDX

2004-05-10 Thread Brook Davies
I certainly will, thanks again! BTW, what is the list etiquette in regard to posting 'Thank you's' , something I've always been unsure of. Should they just go direct to the users email instead of the list? Brook At 03:24 PM 5/10/2004, you wrote: >Well, if that doesn't fix the problem and the al

RE: QofQ with Like returns nullnull error

2004-05-10 Thread Dave Watts
> Sorry, I don't think you can use "LIKE" on QofQ > > I couldn't find any citations to confirm it. Anyone care to > contradict me? Sure, I'll contradict you! According to the CFMX documentation, LIKE is supported, along with the most common wildcards: http://livedocs.macromedia.com/coldfusion/

RE: QofQ with Like returns nullnull error

2004-05-10 Thread J E VanOver
Cool ... is that only in MX?  (I work mostly in 4.5 & 5.0)   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Monday, May 10, 2004 4:13 PM   To: CF-Talk   Subject: RE: QofQ with Like returns nullnull error   > Sorry, I don't think you can use "LIKE" on QofQ   >   > I

Re: CF sending data to a local printer?

2004-05-10 Thread Jonathan Lane
You could take the form output, write it to a text file using CFFILE.  If you've got an Mac OS X box handy, have it dump the files into a folder on there, and attach an Applescript to the folder using folder actions to print all files to the printer (and then delete them). Some people are unfortun

RE: QofQ with Like returns nullnull error

2004-05-10 Thread Dave Watts
> Cool ... is that only in MX?  (I work mostly in 4.5 & 5.0) No, it's in CF 5 also: http://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applicat ions/queryDB11.htm#1117238 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Th

http_referer

2004-05-10 Thread Andrew Grosset
Is there an alternative to cgi.http_referer when checking that a form submission originated from the form page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: http_referer

2004-05-10 Thread JerryEla
Stick a uuid in a hidden field and check that you get the same one back. cgi.http_referer can't be trusted as it can be easily spoofed. Andrew Grosset wrote: > Is there an alternative to cgi.http_referer when checking that a form > submission originated from the form page? > [Todays Threads]

RE: http_referer

2004-05-10 Thread Mike Kear
You can't rely on cgi.http_referer.  Not all browsers pass it.   Either because the software just doesn't, or because the users disable it for privacy reasons.   If you really need to pass that across, then I'd suggest creating a hidden field on the previous page containing cgi.Script_Name that ge

RE: http_referer

2004-05-10 Thread Barney Boisvert
That's just as easy to spoof as http_referer.  Better to do what Jerry suggested and use a UUID in a hidden field that is also stored in the session/client scope for validation on submit. Cheers, barneyb > -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Monday, May

Re: http_referer

2004-05-10 Thread Andrew Grosset
I don't follow...couldn't I just copy the uuid and place it in a hidden field in MY form and submit that? >Stick a uuid in a hidden field and check that you get the same one back. >cgi.http_referer can't be trusted as it can be easily spoofed. [Todays Threads] [This Message] [Subscription]

Re: COM and WDDX

2004-05-10 Thread Rob
On Mon, 2004-05-10 at 15:24, Dick Applebaum wrote: > Well, if that doesn't fix the problem and the alternative is to custom > rewrite the WDDX_COM, then have a look at thinArrays. > > The source is available at: > > http://rohanclan.com/products/neuromancer/ > > this includes: > > --The CFCs t

RE: previous next alphabetical

2004-05-10 Thread Emmet McGovern
BINGO  The ascii was the trick.  Glad you mentioned it.  I never seem to see the simple solution. I ended up doing this.  Since my records will never include any other characters this works like a charm.   index = "i"   from = "97"   to = "122"   step = "1">   SELECT  * F

Re: URL cleansing

2004-05-10 Thread Jochem van Dieten
Paul Vernon wrote: > I've just been playing around with some ideas for cleansing URLs especially > with regards to the injection of SQL code and I came up with the following > piece of code on my test rig: > > > > "\;(.*)(SELECT|DROP|UPDATE|DELETE|TRUNCATE)(.*)$", "", "ALL")> > > > > >

Re: XMLParse() Throwing Error - Shared Hosting

2004-05-10 Thread Massimo Foti
> Thanks for the notice there, I'm forwarding your message on to the owner of > the feed to see if they'll fix it.  However in this instance there was a > double issue - > > The host blocks outgoing calls to those that have been improved ahead of > time.  That is what was causing the error.  CF sim

  1   2   >