Updater Problem - Please help

2010-02-22 Thread E Cohen
Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper

Re: Updater Problem - Please help

2010-02-22 Thread Dave Watts
I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website.  Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper Delete

RE: Updater Problem - Please help

2010-02-22 Thread Mark A. Kruger
[mailto:cft...@longmeadcrossing.com] Sent: Monday, February 22, 2010 5:11 PM To: cf-talk Subject: Updater Problem - Please help Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my coldfusion requests -- any ideas

RE: Updater Problem - Please help

2010-02-22 Thread Mark A. Kruger
-Original Message- From: E Cohen [mailto:cft...@longmeadcrossing.com] Sent: Monday, February 22, 2010 5:11 PM To: cf-talk Subject: Updater Problem - Please help Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all

RE: Updater Problem - Please help

2010-02-22 Thread Mark A. Kruger
Subject: Re: Updater Problem - Please help I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website.  Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError

cfdocument putting part of the row on the bottom of page 1 and the other on the top of page 2. Please help!

2009-03-04 Thread cf coder
Hello everybody, I'm new to cfdocument. I'm using it to create pdf documents from data returned by a query with ColdFusion8. The problem is that cfdocument is putting part of the data contained in the table row at the bottom of page 1 and the other on the top of page 2. I know that there is

Please Help..Confused

2008-09-02 Thread Laurie Smith
I have 3 drop-down boxes for: Years Months Days I need to combine the values for all 3 and convert to days so I can use the total number of days with DateDiff...Any suggestions would be greatly appreciated. Thanks ~| Adobe®

RE: Please Help..Confused

2008-09-02 Thread William Seiter
to this incredible resource. ::-Original Message- ::From: Laurie Smith [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, September 02, 2008 10:01 AM ::To: CF-Talk ::Subject: Please Help..Confused :: ::I have 3 drop-down boxes for: ::Years ::Months ::Days :: ::I need to combine the values for all 3

Re: Please Help..Confused

2008-09-02 Thread Alan Rother
to answer the survey questions, it's a 10 second task , a very small request for access to this incredible resource. ::-Original Message- ::From: Laurie Smith [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, September 02, 2008 10:01 AM ::To: CF-Talk ::Subject: Please Help..Confused :: ::I

Re: Please Help..Confused

2008-09-02 Thread Laurie Smith
I have 3 drop-down boxes for: Years Months Days I need to combine the values for all 3 and convert to days so I can use the total number of days with DateDiff...Any suggestions would be greatly appreciated. Thanks I should have clarified that I am not passing a date such as

Re: Please Help..Confused

2008-09-02 Thread Charlie Griefer
On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith [EMAIL PROTECTED]wrote: I have 3 drop-down boxes for: Years Months Days I need to combine the values for all 3 and convert to days so I can use the total number of days with DateDiff...Any suggestions would be greatly appreciated.

Re: Please Help..Confused

2008-09-02 Thread Alan Rother
Can you explain to goal a little bit... I can see a few uses for such data. For example, is the goal of the date input something like, I need to rent a house for... 2 years, 3 months and 11 days And then you need to calculate what the end date would be starting at Now()? =] -- Alan Rother

Re: Please Help..Confused

2008-09-02 Thread Jake Churchill
If you want the current date to be your starting point, and you want them to select a date in the future using your dropdowns, you'd do this: !--- Create a new date object based on user selections --- cfset newDate =

Re: Please Help..Confused

2008-09-02 Thread Laurie Smith
Can you explain to goal a little bit... I can see a few uses for such data. For example, is the goal of the date input something like, I need to rent a house for... 2 years, 3 months and 11 days And then you need to calculate what the end date would be starting at Now()? =] -- Alan Rother

Re: Please Help..Confused

2008-09-02 Thread Charlie Griefer
On Tue, Sep 2, 2008 at 11:37 AM, Laurie Smith [EMAIL PROTECTED]wrote: On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith [EMAIL PROTECTED] wrote: but... but... some months have a different number of days than others :) if that's your desired result, you'll really need to capture a start

Re: Please Help..Confused

2008-09-02 Thread Laurie Smith
On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith [EMAIL PROTECTED]wrote: but... but... some months have a different number of days than others :) if that's your desired result, you'll really need to capture a start date (and an end date) -- A byte walks into a bar and orders a pint. Bartender

Re: Please Help..Confused

2008-09-02 Thread Phillip M. Vector
In order to get the number of days in (for example) 2 years, 2 months and 2 days, you can do one of the following. 1. Assume a year has 365 days a month has 30 (It doesn't and this will not work correctly for your situation) 2. Use a start date. This is preferable since years, months and days

Re: Please Help..Confused

2008-09-02 Thread Claude Schneegans
I should have clarified that I am not passing a date such as mm/dd/. The year dropdown contains the values 1-5 that the user can select, the month is 1-11, and the days are 1-30. What I am trying to do is for example, when if a user selects 2 years 2 months 2 days then I need to convert

RE: Please Help..Confused

2008-09-02 Thread Robert Harrison
If you mean X years, Y months, and Z days from NOW: cfset newdate=#DateAdd('d',days_value,Now())# cfset newdate=#DateAdd('m',months_value,Now())# cfset newdate=#DateAdd('',years_value,Now())# This will give you a new date that is x years, Y months, and Z days in the future from now. If

RE: Please Help..Confused

2008-09-02 Thread Robert Harrison
3:07 PM To: CF-Talk Subject: RE: Please Help..Confused If you mean X years, Y months, and Z days from NOW: cfset newdate=#DateAdd('d',days_value,Now())# cfset newdate=#DateAdd('m',months_value,Now())# cfset newdate=#DateAdd('',years_value,Now())# This will give you a new date that is x years

Re: Please Help..Confused

2008-09-02 Thread Justin Scott
No, what I need is for example, when if a user selects 2 years (from the years dropdown box) 2 months ( 2 days from the months dropdown box) and 2 days (from the days dropdown box then I need to convert those values to days and add them up. Then that added value will be used with

Re: Please Help..Confused

2008-09-02 Thread Claude Schneegans
I need to convert those values to days and add them up. Ok, but to add them up to WHICH date ? Or do you consider every month to be 30 days and every year to be 365 days in general? If yes, then just use dateAdd (d, form.years*365 + form.months*30 + form.days, dateToBeAdded)

RE: Please Help..Confused

2008-09-02 Thread Robert Harrison
Unless you want to add up the number of days from a specific date, this is not logical, as days in years and months can vary. If it's from a date like today, then: cfset newdate=#DateAdd('d',days_value,Now())# cfset newdate=#DateAdd('m',months_value,newdate)# cfset

Re: CFC confusion. please help!

2008-06-24 Thread Tom Chiverton
On Monday 23 Jun 2008, Matt Williams wrote: One issue with returning an array of objects instead of a query is that if you're talking about lots of records, creating all those objects can become processing and memory intensive. Although with CF8 talking to Flex's RemoteObject, you can use an

RE: CFC confusion. please help!

2008-06-24 Thread Dave Watts
Although with CF8 talking to Flex's RemoteObject, you can use an array of struct with a 'magic key' ('__type__') instead. But then, if you're using Flex Builder, you lose all the autocomplete goodness that you get from having value objects, right? Dave Watts, CTO, Fig Leaf Software

Re: CFC confusion. please help!

2008-06-24 Thread Tom Chiverton
On Tuesday 24 Jun 2008, Dave Watts wrote: an array of struct with a 'magic key' ('__type__') instead. But then, if you're using Flex Builder, you lose all the autocomplete goodness that you get from having value objects, right? Flex Builder keys off the ActionScript value objects, which

Re: CFC confusion. please help!

2008-06-24 Thread Brian Kotek
They __type__ hack is only on the server side, to allow you to pass structures to Flex and fool it into thinking it is a CFC, since CFC creation is too slow when dealing with larger numbers of CFCs. On the Flex side they convert to actual ActionScript classes so you still retain all the code

Re: CFC confusion. please help!

2008-06-24 Thread Tom Chiverton
On Tuesday 24 Jun 2008, Brian Kotek wrote: They __type__ hack is only on the server side, to allow you to pass structures to Flex and fool it into thinking it is a CFC, since CFC creation is too slow when dealing with larger numbers of CFCs. On the Flex side they convert to actual ActionScript

CFC confusion. please help!

2008-06-23 Thread Lori Stone
We are starting to build a new application. We are having major confusion issues regarding the use of cfc's. My boss has a java background but not a coldfusion background. I have been using cfc's since mx came out but not to their full advantage. We have been reading about setter/getter

Re: CFC confusion. please help!

2008-06-23 Thread Rich Kroll
Lori, The reason that some people discourage the use of a query object as a return type is due to the fact that it binds whatever uses that query object directly to the database (more specifically, to the columns in the database). The use of setter/getter beans should be familiar to your boss;

Re: CFC confusion. please help!

2008-06-23 Thread Matt Williams
On Mon, Jun 23, 2008 at 8:36 AM, Lori Stone [EMAIL PROTECTED] wrote: I have always returned query objects but apparently that is not the best practice. I don't understand the problem with returning query objects. I would love to understand the reasoning and what the return type should be.

RE: CFC confusion. please help!

2008-06-23 Thread Jason Durham
for your situation. -Original Message- From: Lori Stone [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 8:36 AM To: CF-Talk Subject: CFC confusion. please help! We are starting to build a new application. We are having major confusion issues regarding the use of cfc's. My boss has

Re: CFC confusion. please help!

2008-06-23 Thread Tom McNeer
One of the things that the other posters (particularly Matt) were getting at is that many times when you return a query object with a number of records, you're not looking to manipulate any of the records (yet). You're often listing records from the database so that one can be chosen for

Re: hello folks How to do paging on looping a list i was confused please help me

2008-04-22 Thread Paul Stewart
or indeed my custom tag cfMagicpager. http://www.stewart-web.co.uk/blog/index.cfm/2008/4/20/Cold It is a different take than Nathan's on pagination. Nathan Strutz wrote: Shariff, I don't know exactly what you are attempting to do, but if you are looking for a way to page your data, you may

hello folks How to do paging on looping a list i was confused please help me

2008-04-21 Thread shariff sml
cfset attributes.ids = ValueList(GetAllAdmins.Author) cfset attributes.perm = ValueList(GetAllAdmins.IsAdmin) cfset adminQueryRaw = QueryNew(empid,lastname,firstname,status) cfset badIDs = cfloop from=1 to=#ListLen(Attributes.ids)# index=ThisPlace cfscript thisemployeeid =

Re: hello folks How to do paging on looping a list i was confused please help me

2008-04-21 Thread Nathan Strutz
Shariff, I don't know exactly what you are attempting to do, but if you are looking for a way to page your data, you may want to look into my Pagination.cfc project. http://paginationcfc.riaforge.org/ If that's not it, perhaps you can elaborate your problem, with the overview, what your goal is,

Re: PDF creation in CF8 - not working...please help

2007-12-11 Thread Rupesh Kumar
Andy, It looks like the rendering engine for html/css in CF does not handle overflow:auto. If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why overflow:auto style does not work. Thanks Regards, Rupesh Adobe ColdFusion team.

Re: PDF creation in CF8 - not working...please help

2007-12-11 Thread Rupesh Kumar
Andy, It looks like the rendering engine for html/css in CF does not handle overflow:auto. If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why overflow:auto style does not work. Thanks Regards, Rupesh Adobe ColdFusion team.

RE: PDF creation in CF8 - not working...please help

2007-12-11 Thread Andy Matthews
Hey Rob... Last night I tried using an absolute path to the stylesheet, and that didn't work either. andy -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 2:47 PM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help

RE: PDF creation in CF8 - not working...please help

2007-12-11 Thread Andy Matthews
: PDF creation in CF8 - not working...please help Andy, Obviously, I don't have enough work ;) or I just like to help. So I debugged a bit for you. If I include the CSS inside the cfdocument tag, I get the colors appropriately inside the PDF, but I get 15 pages, and only the first has data

RE: PDF creation in CF8 - not working...please help

2007-12-11 Thread Andy Matthews
, 2007 6:27 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, It looks like the rendering engine for html/css in CF does not handle overflow:auto. If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why overflow:auto style

Re: PDF creation in CF8 - not working...please help

2007-12-10 Thread Jochem van Dieten
Andy Matthews wrote: I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. Here's the actual

RE: PDF creation in CF8 - not working...please help

2007-12-10 Thread Andy Matthews
...please help Andy Matthews wrote: I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. Here's

Re: PDF creation in CF8 - not working...please help

2007-12-10 Thread Rob Parkhill
Andy, try changing your cfdocument tag to the following: cfdoucument fontembed=no format=pdf /cfdocument I know that when I first started using cfdocument, I had to do this when using CSS on the page that was creating the PDF. Of course the resultant PDF doesn't have the same 'look', but

RE: PDF creation in CF8 - not working...please help

2007-12-10 Thread Andy Matthews
Subject: Re: PDF creation in CF8 - not working...please help Andy, try changing your cfdocument tag to the following: cfdoucument fontembed=no format=pdf /cfdocument I know that when I first started using cfdocument, I had to do this when using CSS on the page that was creating the PDF. Of course

Re: PDF creation in CF8 - not working...please help

2007-12-10 Thread Rob Parkhill
Andy, I guess that you could always design a high level CFR in report builder, and then pass the info that is generated for the proposals as a series of variables, but that seems messy. There is always something like ActivePDF which I was using (and still am on some sites still running 6) to

RE: PDF creation in CF8 - not working...please help

2007-12-10 Thread Andy Matthews
with the CSS. I just don't know why. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 9:21 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, I guess that you could always design a high level CFR in report builder

Re: PDF creation in CF8 - not working...please help

2007-12-10 Thread Rob Parkhill
Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text and images were there. Can you include

RE: PDF creation in CF8 - not working...please help

2007-12-10 Thread Andy Matthews
creation in CF8 - not working...please help Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text

RE: PDF creation in CF8 - not working...please help

2007-12-10 Thread Andy Matthews
- not working...please help Hmmm... Can you try the same test, but use an absolute path to the CSS file? I wonder if I need to do that in my CSS generation, just like with images. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 2:47 PM

Re: PDF creation in CF8 - not working...please help

2007-12-10 Thread Rob Parkhill
Andy, Obviously, I don't have enough work ;) or I just like to help. So I debugged a bit for you. If I include the CSS inside the cfdocument tag, I get the colors appropriately inside the PDF, but I get 15 pages, and only the first has data, the rest is blank, however, when I leave the css

PDF creation in CF8 - not working...please help

2007-12-09 Thread Andy Matthews
I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. Here's the actual page:

Re: PDF creation in CF8 - not working...please help

2007-12-09 Thread Andy Matthews
Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: cfdocument format=pdf all code inside here ... /cfdocument ~| Enterprise web applications, build robust,

Re: PDF creation in CF8 - not working...please help

2007-12-09 Thread Andy Matthews
Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: cfdocument format=pdf /cfdocument ~| Enterprise web applications, build robust, secure scalable apps today

Re: Returns the value, 16,16?? Please help!

2007-10-12 Thread Tom Chiverton
On Thursday 11 Oct 2007, [EMAIL PROTECTED] wrote: You'll get smarter answers if you say some words in your post. Sometimes I thing someone is testing a Turing entry... -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ?

Returns the value, 16,16?? Please help!

2007-10-11 Thread Candice toro
cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif

Re: Returns the value, 16,16?? Please help!

2007-10-11 Thread Matt Robertson
honestly, I haven't read the code posted, but I can say with certainty that you get a comma-delimited list in a single form field if you are submitting it twice. You'll get smarter answers if you say some words in your post. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com

Re: Returns the value, quot;16,16quot;?? Please help!

2007-10-11 Thread Janet MacKay
You'll get smarter answers if you say some words in your post. While I have to agree, I suspect you problem is your form uses method=get and you're appending #CGI.QUERY_STRING# to the action page. That will duplicate your parameter values. cfform

please help with CF8 install

2007-10-10 Thread Phill B
I have been trying to get CF8 to install on a Win 2k3 server for two nights now and with out success. I'm having the same problem that I've had with CF 7 and the wsconfig. This is the error in the connectorinstall0.txt file could not connect to port 2930 on host 127.0.0.1

Re: please help with CF8 install

2007-10-10 Thread Andy Allan
Did you try to hook up the Web Server during the install process? Or did you initially install with the built in web server and are now running wsconfig afterwards? Just looking to see if CF actually installed OK. Is there a firewall blocking port 2930? Is there something else already using port

Re: please help with CF8 install

2007-10-10 Thread Azadi Saryev
afaik, win 2k3 server disables port scanning, which is what cf installer does looking for port 2930. i have come across a blog post with solution on how to temporarily allow port scanning / run specific jndi init line, but can't recall on which blog now it could have been on adobe cf

RE: please help with CF8 install

2007-10-10 Thread Asha K S
Thanks, Asha. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 1:43 PM To: CF-Talk Subject: Re: please help with CF8 install Did you try to hook up the Web Server during the install process? Or did you initially install with the built in web server

Re: please help with CF8 install

2007-10-10 Thread Phill B
Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 1:43 PM To: CF-Talk Subject: Re: please help with CF8 install Did you try to hook up the Web Server during the install process? Or did you initially install with the built in web server and are now running wsconfig

Re: please help with CF8 install

2007-10-10 Thread Phill B
/viewContent.do?externalId=8a0aaf29slice Id=2 Thanks, Asha. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 1:43 PM To: CF-Talk Subject: Re: please help with CF8 install Did you try to hook up the Web Server during the install process? Or did

RE: please help with CF8 install

2007-10-10 Thread Dave Watts
I ran netstat and didnt see anything with port 2930. Giggity giggity!! Turning off the TCP/IP filtering fixed it. Thanks for the help! Now I can sleep tonight. Giggity giggity!! I'm afraid to ask what you're doing with those ports, exactly. Dave Watts, CTO, Fig Leaf Software

Please Help - deploying CF 7.2 enterprise on Jrun 4 / unix

2007-09-14 Thread Giles Roadnight
Hi All I'm having some problems with an install of CF 7. I was running a deply script that had previously worked fine but this time it messed up CF server. When I opened a page it said: There is no web application configured to service your request When I look at the JRun Management Console

reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Jide Aliu
I have a body of text, in the body of text I want to replace all image tags with the value of the src attribute, so for example below This is the body it can be as long as 8,000 character but within the body here is the image tag img alt= height=150

RE: reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Bobby Hartsfield
: reReplaceNoCase() problem from a newbie, please help I have a body of text, in the body of text I want to replace all image tags with the value of the src attribute, so for example below This is the body it can be as long as 8,000 character but within the body here is the image tag img alt= height=150

Re: reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Jide Aliu
Hartsfield http://acoderslife.com -Original Message- From: Jide Aliu [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 5:46 AM To: CF-Talk Subject: reReplaceNoCase() problem from a newbie, please help I have a body of text, in the body of text I want to replace all image

RE: reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Bobby Hartsfield
-Original Message- From: Jide Aliu [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 10:44 AM To: CF-Talk Subject: Re: reReplaceNoCase() problem from a newbie, please help Thanks Bobby for taking time out for the solution, that did the trick. It's the start of my problem on the solution though

Re: reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Jide Aliu
:44 AM To: CF-Talk Subject: Re: reReplaceNoCase() problem from a newbie, please help Thanks Bobby for taking time out for the solution, that did the trick. It's the start of my problem on the solution though how would you go about reReplacing the same item with the tags below in a body of text/string

Re: reReplaceNoCase() problem from a newbie, please help

2007-06-14 Thread Jide Aliu
:44 AM To: CF-Talk Subject: Re: reReplaceNoCase() problem from a newbie, please help Thanks Bobby for taking time out for the solution, that did the trick. It's the start of my problem on the solution though how would you go about reReplacing the same item with the tags below in a body of text/string

RE: Please Help! ORA-01704: string literal too long Error (CFMX)

2007-04-17 Thread Dave Watts
I have a situation where well-formed INSERT or UPDATE pass-thru queries fail through the native Oracle driver, but executes successfully in Toad or SQL*Plus: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long I'm running CFMX 6.1 and Oracle 10G. I've

Please Help! ORA-01704: string literal too long Error (CFMX)

2007-04-17 Thread Brad Stone
All: I have a situation where well-formed INSERT or UPDATE pass-thru queries fail through the native Oracle driver, but executes successfully in Toad or SQL*Plus: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long I'm running CFMX 6.1 and Oracle 10G. I've verified

Re: Please Help! ORA-01704: string literal too long Error (CFMX)

2007-04-17 Thread Doug Bezona
Wow, haven't run into that one in a long time. Some of this is from the CF 5 days, but one or a combination of these should help. 1. Make sure there aren't any restrictions set on the datasource in the ColdFusion administrator (Enable retrieval of long text disabled, etc.) 2. Try a different

please help me to debug this code... thanks

2007-03-16 Thread Adrian C .
redirects me with : http://192.168.1.7/?CFID=500CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also this one used ssl certificate, but I don't want to use it anymore. code below. thanks. a paypal

please help me to debug this code

2007-03-16 Thread Adrian C.
redirects me with : http://192.168.1.7/?CFID=500CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also this one used ssl certificate, but I don't want to use it anymore. code below. thanks. a paypal

RE: please help me to debug this code... thanks

2007-03-16 Thread Adkins, Randy
PROTECTED] Sent: Friday, March 16, 2007 12:20 PM To: CF-Talk Subject: please help me to debug this code... thanks redirects me with : http://192.168.1.7/?CFID=500CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name

RE: please help me to debug this code... thanks

2007-03-16 Thread Adkins, Randy
What is the problem? I see that as long as your are running on PORT 80, you will get redirected as indicated cfif server_port is '80' cflocation addtoken=Yes url=http://192.168.1.7; Are you expecting something else??

Re[2]: please help me to debug this code... thanks

2007-03-16 Thread Adrian C.
, March 16, 2007 12:20 PM To: CF-Talk Subject: please help me to debug this code... thanks redirects me with : http://192.168.1.7/?CFID=500CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also

CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Axel Jensen
I'm trying to create a most recently updated list of tracks that we update, and track our bugs, and feature requests with. The list that I want will end up looking like this. (where the query ends up just grabbing the most recent results, and doesn't duplicate. 921028 Northern

Re: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Jim Wright
Axel Jensen wrote: I'm trying to create a most recently updated list of tracks that we update, and track our bugs, and feature requests with. SELECT DISTINCTe.createdByUserID,i.itemID, i.title, e.datecreated FROMevents e JOINv_items i ON e.itemID = i.itemID

Re: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Rick Root
You need a group by and an aggregate function: SELECT DISTINCTe.createdByUserID,i.itemID, i.title, max(e.datecreated) FROMevents e JOIN v_items i ON e.itemID = i.itemID WHERE e.createdbyuserid = 92 GROUP BYe.createdByUserID, i.itemID, i.title

Re: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Rick Root
(if I forgot to exclude it.. do NOT use the distinct in that query) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four

RE: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Brad Wood
I place my vote with Jim and Rick. They beat me to it. ~Brad -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 9:44 AM To: CF-Talk Subject: Re: CALLING ALL SQL EXPERTS, Please help You need a group by and an aggregate function: SELECT

Re: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Teddy Payne
Can you provide a sample of the table prior to your joins so that I may see your foreign keys. Teddy On 11/16/06, Axel Jensen [EMAIL PROTECTED] wrote: I'm trying to create a most recently updated list of tracks that we update, and track our bugs, and feature requests with. The list that

RE: CALLING ALL SQL EXPERTS, Please help

2006-11-16 Thread Axel Jensen
Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 9:48 AM To: CF-Talk Subject: Re: CALLING ALL SQL EXPERTS, Please help Can you provide a sample of the table prior to your joins so that I may see your foreign keys. Teddy On 11/16/06, Axel Jensen [EMAIL

PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would

Re: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Tom King
Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why

Re: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Tom King
Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
[mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:52 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not

Re: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Tom King
Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work

Re: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Tom Chiverton
On Wednesday 18 October 2006 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written

Re: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Tom King
the error on page or is it not writing any HTML file? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
: PLEASE HELP! Why is this application.cfc erroring out? Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T ~| Introducing the Fusion Authority Quarterly Update. 80 pages

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
Just tried restarting the CF machine... Still same errors :( .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

RE: PLEASE HELP! Why is this application.cfc erroring out?

2006-10-18 Thread Ben Nadel
on. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out

  1   2   3   4   5   6   7   >