RE: Daily Tip help...
Thanks Tony, I have it working good now... here is The Tip Of The Day code incase anyone is wants to do the same. I set up the scheduler to run this once a day. I may set it every hour. -Code-- !--- reset all tips to inactive --- cfquery name=clear_active datasource=myDSN UPDATE Tips SET active = 0 /cfquery !--- Lets Count the Records --- cfquery name=CountRecords datasource=myDSN SELECT COUNT(Tips.Tip_ID) AS maxrecords FROM Tips /cfquery !--- Set the random record --- cfset RandomCount = randRange(1, #CountRecords.maxrecords#) !--- Now set the new tip as active --- cfquery name=set_new datasource=myDSN UPDATE Tips SET active = 1 WHERE tip_id = #RandomCount# /cfquery --END- Then all I do is output the active tip. Thanks for the help Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 8:52 PM To: CF-Talk Subject: RE: Daily Tip help... or, actually... cfquery name=set_new datasource=myDSN UPDATE tips SET active_tip = 1 WHERE tip_id = #randRange(1-100) --if you have 100, or whatever your total is /cfquery since you probably will not have a 0 :) also, your integer mismatch was most likely on the new() creating a uuid there, and not an INT which that column seems to be. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfmail - how to tell when sent
Hi I've got a txt file that is generated on the fly, then sent with cfmail as an attachment. I then want to delete it (after I KNOW that it has been sent) If I do a delete with cffile immed after the cfmail tag, the delete works before the file is actually sent, Does anyone know a way of testing that a file has been sent by cfmail? I'm using MX Many thanks Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regular Expression Help
On CFMX
stTmp = REFindNoCase('msg:(.*?);',str,1,true);
if(stTmp.pos[1]){
message = Mid(str,stTmp.pos[2],stTmp.len[2]);
}
else {
message = ;
}
ON CF5
stTmp = REFindNoCase('msg:(([^]|[^;])*);',str,1,true);
if(stTmp.pos[1]){
message = Mid(str,stTmp.pos[2],stTmp.len[2]);
}
else {
message = ;
}
-Original Message-
From: Ian [mailto:[EMAIL PROTECTED]
Sent: maandag 17 mei 2004 22:39
To: CF-Talk
Subject: Regular _expression_ Help
I'm trying to parse a string and pluck a bit of text, but my
regex isn't working :( Here's a sample string:
(msg:My Message Here; content:My Content Here;)
I want to return My Message Here.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: brain fart on #'s
Tony, Tony Weeg wrote: cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif You need your row reference on get.yournamehere. Also, its better html if you put the close option tag in there too. ;o) option value=0#get.yournamehere[i]#/option Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
ON CF5
cfscript
start = 1;
aLog = ArrayNew(1);
commentRegexp = [*]{3}[[:space:]]+([^*]*)[[:space:]]+[*]{3};
timestampRegexp =
[0-9]{1,2}/[0-9]{2}/[0-9]{4}[[:space:]]+[0-9]{2}:[0-9]{2}:[0-9]{2};
while(true){
stTmp = REFind(commentRegexp,str,start,true);
if(stTmp.pos[1]){
stLog = StructNew();
header = Mid(str,stTmp.pos[2],stTmp.len[2]);
stTmp2 = REFind(timestampRegexp,header,1,true);
if(stTmp2.pos[1]){
stLog.user =
Trim(Removechars(header,stTmp2.pos[1],stTmp2.len[1]));
stLog.timestamp =
Mid(header,stTmp2.pos[1],stTmp2.len[1]);
}
else{
stLog.user = Trim(header);
stLog.timestamp = ;
}
stLog.text = ;
if(ArrayLen(aLog)){
aLog[ArrayLen(aLog)].text =
Mid(str,start,stTmp.pos[1]-start);
}
ArrayAppend(aLog,stLog);
start = stTmp.pos[1]+stTmp.len[1];
}
else{
if(ArrayLen(aLog)){
aLog[ArrayLen(aLog)].text =
Trim(Mid(str,start,Len(str)-start));
}
break;
}
}
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(aLog)# index=i
div class=timestamp#aLog[i].user# #aLog[i].timestamp#/div
pre#aLog[i].text#/pre
/cfloop
/cfoutput
ON CFMX
cfscript
start = 1;
aLog = ArrayNew(1);
commentRegexp =
[*]{3}\s+(.*?)\s+[*]{3}(.*?)(?=([*]{3}\s+.*?\s+[*]{3})|$);
timestampRegexp = \d{1,2}/\d{2}/\d{4}\s+\d{2}:\d{2}:\d{2};
while(true){
stTmp = REFind(commentRegexp,str,start,true);
if(stTmp.pos[1]){
stLog = StructNew();
header = Mid(str,stTmp.pos[2],stTmp.len[2]);
stTmp2 = REFind(timestampRegexp,header,1,true);
if(stTmp2.pos[1]){
stLog.user =
Trim(Removechars(header,stTmp2.pos[1],stTmp2.len[1]));
stLog.timestamp =
Mid(header,stTmp2.pos[1],stTmp2.len[1]);
}
else{
stLog.user = Trim(header);
stLog.timestamp = ;
}
stLog.text = Mid(str,stTmp.pos[3],stTmp.len[3]);
ArrayAppend(aLog,stLog);
start = stTmp.pos[1]+stTmp.len[1];
}
else{
break;
}
}
/cfscript
The script on CF5 breaks if you have * between *** ***
The script on CFMX doesn't
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: maandag 17 mei 2004 17:39
To: CF-Talk
Subject: Re: help with string manipulation (Find,Replace)
Thanks Pascal. Sorry again for any inconvenience caused.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: brain fart on #'s
Just a shot in the dark, but couldn't CF misinterpret the var get. It looks like it's seeing it as something else. Did you try dumping get? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 5:44 To: CF-Talk Subject: brain fart on #'s what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif gives me... You have attempted to dereference a scalar variable of type class java.lang.Integer as a structure with members. tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: using the result of CFDIRECTORY as a list
Using cfdirectory action="" directory=qList ... returns a query, not a list. You should use it as a query. If you absolutly want a list you can do ValueList(qList.name). Be aware that it also lists directories. If you use a filter as you do, this shouldn't be a problem. Pascal -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 6:06 To: CF-Talk Subject: using the result of CFDIRECTORY as a list I'm using CFDIRECTORY to get a list of files that meet certain parameters. Sometimes one of the file doesn't exist. And here's the trouble. I can't seem to use CFDIRECTORY as a list. I keep getting the complex object type error. I can produce a list of a files that should exist, I would like to compare that to the files that do exist. Been spinning my wheels on this one. Gil Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmail - how to tell when sent
On Tuesday 18 May 2004 09:33 am, Seamus Campbell wrote: If I do a delete with cffile immed after the cfmail tag, the delete works before the file is actually sent, You need to change the spool settings (spoolEnable ?). -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
cf coder wrote:
Hi Robert,
apologies for causing any confusion. I was asked to present the data
stored in the database table column in a certain way. Historically
data stored in this column is as under:
timestamp
comments
EX:
*** 05/12/2003 09:52:10 USER1 ***
closing if fixed - awaitng response from User2
I was asked to get rid of the stars and reorder the timestamp to
something like this:
USER1 05/12/2003 09:52:10
(Username, Date, Time)
All comments (timestamps) added henceforth will be added in this fashion.
I hope this gives you a better understanding. The solution Pascal
provided does just that and it does the job for me.
Best Regards,
cfcoder
Ummm This thread has been going on and on and I can't help but feel
that this is overcomplicated this somewhat...
Your comment is a string with a number of lines in it. Your date/time
stamp is denoted by being started and finished with 3 asterisks.
Wouldn't this be simpler?
cfscript
//create new query for this record's Comment/LogField entry
thisLogQuery = QueryNew();
QueryAddColumn(thisLogQuery,UserID);
QueryAddColumn(thisLogQuery,logDate);
QueryAddColumn(thisLogQuery,logTime);
QueryAddColumn(thisLogQuery,Comment);
for (i=1;i lTE ListLen(LogField,chr(13)); i=i+1) {
thisLogLine = trim(ListGetAt(LogField,i));
if (ListFirst(thisLogLine, ) EQ ***) {
// new date stamp, new row
QueryAddRow(thisLogQuery);
if (IsDate(ListGetAt(thisLogLine,2, )){
// Check for old format with date first
QuerySetCell(thisLogQuery,logDate,ListGetAt(thisLogLine,2,
));
QuerySetCell(thisLogQuery,logTime,ListGetAt(thisLogLine,3,
));
QuerySetCell(thisLogQuery,UserID,ListGetAt(thisLogLine,4, ));
} else {
// otherwise use new format
QuerySetCell(thisLogQuery,UserID,ListGetAt(thisLogLine,2, ));
QuerySetCell(thisLogQuery,logDate,ListGetAt(thisLogLine,3,
));
QuerySetCell(thisLogQuery,logTime,ListGetAt(thisLogLine,4,
));
}
} else
QuerySetCell(thisLogQuery,Comment,thisLogQuery.Comment[recordcount]chr(13)thisLogLine);
}
/cfscript
You end up with a nice wee query of all the log entries for a record,
new and old user/date/time stamps are handled, handles comments with
multiple lines, it'll be easier to display the contents of the query, it
should work in both CF5 and CFMX and anyone looking at it later can read
the code!
FOOT NOTE:I just typed this in off the top of my head.I haven't run
the code, or checked it in anyway.You may need to tweak it or it might
need minor debugging..
Regards
Stephen
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: help with string manipulation (Find,Replace)
thisLogLine = trim(ListGetAt(LogField,i)); Whoops Immediately spotted an error : thisLogLine = trim(ListGetAt(LogField,i,chr(13))); Forgot to put the list delimiter in to get one line out of the comments/LogField. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_Web_services preparation for consumption
On Monday 17 May 2004 18:40 pm, [EMAIL PROTECTED] wrote: 1) How can I prevent these Affiliates from using these Web services as live data feeds to populate their Web pages?Can I somehow restrict the number of hits/bytes to these Web services? You want some sort of access control in the main service CFC, that then passes the request onto the main worker CFC if all is well. You can then time-limit the access for a particular service... I'm thinking. * user logs on OK * user gets list of services can invoke, and an ID - server stores id,timestamp * service CFC receives ID, serviceName - checks timestamp of ID * if OK, invoke serviceName 2) What's the best way to present example code for the various application development laungauges? If you don't know, or know someone who knows, your better of not giving any, than having an example that breaks because of some subtly of the language. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Advanced session mgt?
On Monday 17 May 2004 17:21 pm, Katz, Dov B (IT) wrote: NOTICE: If received in error, please destroy and notify sender. I can't do both, can I :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFChart and the Y-Axis
On Monday 17 May 2004 20:05 pm, DURETTE, STEVEN J (AIT) wrote: Anyone know how to make this happen? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a11.htm#wp2619630 You want the gridlines attribute. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFChart and the Y-Axis
Thanks, that did the trick. I actually looked at gridlines before and I remember thinking the number of lines won't help me!As you can tell my brain wasn't working that day. Steve -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 6:54 AM To: CF-Talk Subject: Re: CFChart and the Y-Axis On Monday 17 May 2004 20:05 pm, DURETTE, STEVEN J (AIT) wrote: Anyone know how to make this happen? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a11.htm#wp261963 0 You want the gridlines attribute. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Daily Tip help...
I have several of these things,displaying random tips or random quotes. They all work flawlessly in SQLServerwith a query like: Select top 1 Tipid, Tip, Source, SourceEMail from Tips Order By NEWID() Each time the query is run, it produces a query containing a single record taken at random from the table.If you wanted to run it only once per day, you could put it in a scheduled task, and put the result into an application variable, or perhaps have a CACHEWITHIN parameter set in the CFQUERY tag. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 May 2004 12:52 PM To: CF-Talk Subject: RE: Daily Tip help... or, actually... cfquery name=set_new datasource=myDSN UPDATE tips SET active_tip = 1 WHERE tip_id = #randRange(1-100) --if you have 100, or whatever your total is /cfquery since you probably will not have a 0 :) also, your integer mismatch was most likely on the new() creating a uuid there, and not an INT which that column seems to be. tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Reporting Tools
I have a need to produce some simple reports using Cold Fusion. They are simple, text only reports, but I must have control over page layout, the ability to put row headers and the like on every page,etc. Currently, we have a VB app that generates these reports using Crystal on an Access database, but I'd like to generate the reports on the web server using a web service, and produce a link to the generated report. I'm looking at one open source tool called jasper reports (http://jasperreports.sourceforge.net) that looks like it has potential. I wondered if anyone has successfully integrated this particular solution? Any other suggestions? Thanks. Rick Root [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Thanks Pascal, your script works just fine. Thanks again for your help, most appreciated. Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
-Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 12:38 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) You end up with a nice wee query of all the log entries for a Do you mean that queries are easier than arrays of structs. I hardly see a difference. Creating a query takes more work, but displaying an array takes more work too. So I think it's a question of personal prefference (or what you need to do with it later). record, new and old user/date/time stamps are handled, Your code handels old and new comments, but not comments without datestamp. It also doesn't handle user names with spaces in it. handles comments with multiple lines, it'll be easier to display the contents of the query, it should work in both CF5 and CFMX and anyone looking at it later can read the code! The code for cf5 will work in cfmx too, but do you imply that you can't write cfmx specific code and use new features because you want everything to be cf5 compattible? I admit that the code lacked comment, but I have a lot of work at the moment and was writing this quickly to help him out. Are you implying that we shouldn't use regexp, because other developers my not understand it when they read it later? I think regexps is one of the most powerfull tools when it comes to parsing. Just because some people don't understand it, doesn't mean we shouldn't use it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
I agree with Pascal, regexps are the most powerfull tools when it comes to parsing, however they are not easy to code. Pascal I was wondering if you could explain what your code is doing:
commentRegexp = [*]{3}\s+(.*?)\s+[*]{3}(.*?)(?=([*]{3}\s+.*?\s+[*]{3})|$);
timestampRegexp = \d{1,2}/\d{2}/\d{4}\s+\d{2}:\d{2}:\d{2};
Many thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Reporting Tools
Upgrade to SQL2K and download/get SQL Reporting Tools - very very good and free. _ From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 12:56 To: CF-Talk Subject: Reporting Tools I have a need to produce some simple reports using Cold Fusion. They are simple, text only reports, but I must have control over page layout, the ability to put row headers and the like on every page,etc. Currently, we have a VB app that generates these reports using Crystal on an Access database, but I'd like to generate the reports on the web server using a web service, and produce a link to the generated report. I'm looking at one open source tool called jasper reports (http://jasperreports.sourceforge.net) that looks like it has potential. I wondered if anyone has successfully integrated this particular solution? Any other suggestions? Thanks. Rick Root _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)
Dave, We found that whenever we used transactions, an error would be written to our log files, but not thrown to screen. However, if you have the username and password set up with the datasource in the cf administrator then you wouldn't get any errors. We've resorted to doing that for some apps, and moving transactional logic to stored procs for others. No fun. But, it's the only solution we've come up with so far (Oracle 8i). - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:39 PM Subject: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...) We had similar problems that were resolved by reverting the 6.1 database drivers to the 6.0+ version available at the related TechNote (http://www.macromedia.com/support/coldfusion/ts/documents/cfm x61_sqlserver_cpu.htm). Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have luck with those, but we continued to have problems, so we're still on the 6.0+ drivers. Out of curiosity, are you having the same problems with the 3.3 drivers that you were with the 3.2 drivers? What database server are you using? For our SQL Server clients, we've successfully deployed the MS JDBC drivers in some cases. Just as a quick follow-up, I have isolated down the scenario that creates the removeOnExceptions warning. If I use the cftransaction tag around my queries, the warning is thrown. If I don't, no warning appears. Any idea what the issue might be? Is this a bug I need to follow up with Macromedia? As a test with Oracle 8i/9i: cftransaction action=""> cfquery name=get datasource=myDSN SELECT sysdate FROM dual /cfquery cfquery name=get2 datasource=myDSN SELECT sysdate FROM dual /cfquery /cftransaction cfdump var=#get# expand=Yes / cfdump var=#get2# expand=Yes / This will throw the following warning to my log file: removeOnExceptions is true for myDSN, closed the physical Connection If I comment out the cftransaction tags, nothing is thrown. As I said, over time and under load this eventually brings the instance to a grind. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running r equests...)
From: Dave Watts I would check out the DataDirect support documents first, then if you don't find an answer there, I'd talk to MM tech support. They did a lot of work testing the 3.3 drivers before releasing them. Interesting...they bring our servers to an immediate crashing halt with about 5 open connections to our Oracle database. We've also rolled back to the 3.1 drivers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JavaScript RegEx bug in NS6?
There are only 4 people still using it, so forget it. Yes, it may seem like that, but not according to our logs!We still get thousands of requests from NS6 users each month. Anyway, I'm nit-picky about these things and prefer that my code have as few version issues as possible.My job is to make it easier for customers to do business with us rather than more difficult.I don't like to say Sorry, but we can't write an app that will work for you--please modify YOUR system instead.Yech. Also, it looks like it may be NS6 on WinXP.NS6 on Win98 does not have the issue.So does anyone have a workaround? Thanks again, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
what am I doing wrong (#'s question)
what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif im being told that im trying to dereference a scalar variable, something, blah. still brain farting this morning on this one... thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
Did you dump get?? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 15:59 To: CF-Talk Subject: what am I doing wrong (#'s question) what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif im being told that im trying to dereference a scalar variable, something, blah. still brain farting this morning on this one... thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)
Dave, We found that whenever we used transactions, an error would be written to our log files, but not thrown to screen. However, if you have the username and password set up with the datasource in the cf administrator then you wouldn't get any errors. Thanks for the confirmation on what I'm seeing. However, I'm a bit confused on your workaround. Are you saying that if you define the user name and password in the MX Administrator then you don't get the error? If so, that's not what I'm seeing. I define the user name and password in the MX Admin for my datasource and still see thing problem. Again though, I may be misunderstanding what you mean. We've resorted to doing that for some apps, and moving transactional logic to stored procs for others. No fun. But, it's the only solution we've come up with so far (Oracle 8i). Yeah, I've been pushing to move our SQL, particularly the transactional queries, entirely into Oracle packages. However, I'm a one-man show as far as CF development at my company, so getting the time to refactor my inherited code base is slim to none at this point. Oh well, thanks again for confirming what I'm seeing. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: what am I doing wrong (#'s question)
cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# Don't you need an array referent for get.yournamehere[]? --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
sure. but whats that going to get me :) I know what that gets me... this has nothing to do with the dump of get. it has to do with looping, and in the []'s parsing the value of request.nextRecord so that I get the next line during that iteration. tony -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:07 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) Did you dump get?? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 15:59 To: CF-Talk Subject: what am I doing wrong (#'s question) what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif im being told that im trying to dereference a scalar variable, something, blah. still brain farting this morning on this one... thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: what am I doing wrong (#'s question)
Original Message: From: Tony Weeg option value=0 #get.yournamehere# As someone already suggested, it's probably this line.You're not telling which row you're accessing get.yournamehere from. (and, also as suggested, close your option tag :) ) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
yes. but im good on that... just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. that's all. tw -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 AM To: CF-Talk Subject: Re: what am I doing wrong (#'s question) cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# Don't you need an array referent for get.yournamehere[]? --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
Can you post more of your code? Need to see if your look is going too far -Original Message- From: Tony Weeg what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif im being told that im trying to dereference a scalar variable, something, blah. still brain farting this morning on this one... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. tw -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:10 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) yes. but im good on that... just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. that's all. tw -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 AM To: CF-Talk Subject: Re: what am I doing wrong (#'s question) cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# Don't you need an array referent for get.yournamehere[]? --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
From: Tony Weeg just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. Your # usage is correct on that line Since it's within a CFIF, then you don't need any at all [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
COM objects on MX
Hi, I am new to the list. And yes, I did do a search of the archives, but keep getting inconsequential results. So what's new with COM objects and CFMX? I need to manipulate Powerpoint presentations/slides, a process which worked just fine on CF 5. The Java-COM bridging that I tried to look into some time back seems to be the way to go, but I wanted to ask the folks here: what is the most rewarding route to CFMX-COM nirvana (is that too strong a word)? Regards, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
didn't think so. so, do I need some (Apostrophe's) there or something? tony -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:20 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) From: Tony Weeg just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. Your # usage is correct on that line Since it's within a CFIF, then you don't need any at all [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
Tony, I think what they are trying to tell you is that: option value=0 #get.yournamehere# needs to have an appearance similar to get.companyIdNumber[request.nextRecord] Note that get.column[index] != get.column so #get.column# is not a simple value - I think you are trying to do ... cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0#get.yournamehere[request.nextRecord]#/option /cfif ... Though that is untested on my part. It could be get.index.column I forget ... I'd have to run it. Cheers On Tue, 2004-05-18 at 07:08, Tony Weeg wrote: sure. but whats that going to get me :) I know what that gets me... this has nothing to do with the dump of get. it has to do with looping, and in the []'s parsing the value of request.nextRecord so that I get the next line during that iteration. tony -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:07 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) Did you dump get?? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: dinsdag 18 mei 2004 15:59 To: CF-Talk Subject: what am I doing wrong (#'s question) what the heck am I doing wrong? brain fart on the: get.companyIdNumber[request.nextRecord] part of this... cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# /cfif im being told that im trying to dereference a scalar variable, something, blah. still brain farting this morning on this one... thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Array problems
This array works but it keeps incrementing values in each row. Using CFDUMP values for the first row appear with a comma in the second row along with its values. Why doesn't it generate a new row? Please help... Tried moving CFIF isDefined(form.more.x) to no avail.
cfif not isDefined('session.item')
cfset session.item=arrayNew(2)
/cfif
form action="" method=POST
CFOUTPUT
input type=text name=qty size=4
input type=text name=item size=50
input type=text name=priceeach size=8
CFIF isDefined(form.more.x)
cfset arrayLength=arrayLen(session.item)
cfset session.item[variables.arrayLength+1][1]=form.qty
cfset session.item[variables.arrayLength+1][2]=form.item
cfset session.item[variables.arrayLength+1][3]=form.priceeach
/cfif
/CFOUTPUT
input type=image src="" name=more value=more
/form
Robert O.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: what am I doing wrong (#'s question)
man. ill shut up. as I said, brain fart. it was something else, a line or two up :) hee. cya. good Tuesday. later. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:16 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) didn't think so. so, do I need some (Apostrophe's) there or something? tony -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:20 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) From: Tony Weeg just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. Your # usage is correct on that line Since it's within a CFIF, then you don't need any at all [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: what am I doing wrong (#'s question)
Tony Weeg wrote: cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. Ok there's nothing wrong in this bit of code.Like Phil just asked, can you post some more code and the whole of the error message including the line its telling you the error is on etc Its sounding like its something to do with your surrounding code rather than anything here. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Exception Handling Frameworks?
A CFC/modeling/design related question: I am in the process of creating an application that CFTHROWS several different types of custom exceptions in several parts of the application. They include: 1) Form validation errors 2) Business logic validation errors 3) Database errors 4) Unexpected application errors..plus a few more Each error type differs slightly in the type of context-sensitive custom information that is added to the CFCATCH struct when the exception in caught. Form validation errors and business logic errors often include a hint that is added in the catch block, then read and output by the UI layer. Other errors caught in the application have other custom data items added used for logging and debugging. The end result is that various parts of the application listen for specific types of errors and process them when they're found. ** The problem is there is no consistency between the error data structures, how the data is analyzed, and how the application decides what to do with the error information. ** So, the question: has anyone done a Java-style system of using something like ErrorManager.cfc/Error.cfc, where each exception creates a new error object, and the ErrorManager.cfc is queried to receive error information? Not looking to copy anyone's code here - just some guidance on a solid approach! Much appreciated! -- Alex Sherwood PHS Collection Agency [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: what am I doing wrong (#'s question)
Does it error the first time through the loop?Or after a while? How is i generated? What is the specific error generated? --Ben Doom Tony Weeg wrote: cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. tw [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
thanks ben. read my last post. it was, as I said, a brain fart. thanks! tony -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:25 AM To: CF-Talk Subject: Re: what am I doing wrong (#'s question) Does it error the first time through the loop?Or after a while? How is i generated? What is the specific error generated? --Ben Doom Tony Weeg wrote: cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. tw [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
Maybe a little more info may help. This CFHTTP call is part of a loop over account numbers. It appears that the first loop passes CFHTTPPARAM's correctly through to the next page. It writes to my home brew log file the correct 5 variables. As it gets to the NEXT applicable one in sequence it writes this stuff in its place HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:24085 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,application/x-www-form-urlencoded,application/x-www-form-urlencode d,application/x-www-form-urlencod .etc Here is the kicker, on a CF 5.0 seperate server this cfhttp call works perfectly, now using 6.0 it doesn't seem to be working and I am getting these errors. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:29 PM To: CF-Talk Subject: RE: Weird CFHTTP Error Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running r equests...)
From: Dave Watts I would check out the DataDirect support documents first, then if you don't find an answer there, I'd talk to MM tech support. They did a lot of work testing the 3.3 drivers before releasing them. Interesting...they bring our servers to an immediate crashing halt with about 5 open connections to our Oracle database. We've also rolled back to the 3.1 drivers. This is what happens to us as well. I have not found anything on DataDirect's support site that relates to this problem, so I guess the next step is MM support. Unfortunately, I don't have time to get into this with them right now. The 3.1 drivers will have to suffice for a bit longer. They haven't caused us any headaches thus far. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
Did you try/catch/dump/mail your ERROR HANDLER?I think your handler is throwing an error. Several changes occured in MX that made code that worked in cf5 break (for example, naming variables something.something is illegal in CFMX, without first defining the structure). You might want to check your error handler for deprecated syntax. Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 A To: CF-Talk Subject: RE: Weird CFHTTP Error Maybe a little more info may help. This CFHTTP call is part of a loop over account numbers. It appears that the first loop passes CFHTTPPARAM's correctly through to the next page. It writes to my home brew log file the correct 5 variables. As it gets to the NEXT applicable one in sequence it writes this stuff in its place HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:24085 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,application/x-www-form-urlencoded,application/x-www-form-urlencode d,application/x-www-form-urlencod .etc Here is the kicker, on a CF 5.0 seperate server this cfhttp call works perfectly, now using 6.0 it doesn't seem to be working and I am getting these errors. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:29 PM To: CF-Talk Subject: RE: Weird CFHTTP Error Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Need SQL Advice
Hi, I need some advice here, there are two tables in a database that I am concerned with here. One is called say dbo.Trucks and the other is dbo.ReportingData. dbo.Trucks stores all the information regarding all customer trucks, customers could have one truck, others could have 50. There is a column named totalMileage [datatype float] within dbo.Trucks. dbo.Trucks table design (there is other data, but this all I am concerned with) TRUCKID | CUSTOMERID | TOTALMILEAGE dbo.ReportingData has each vehicles reporting data. A unit sends a gps report from the vehicle to our DSN every ten minutes when the vehicle is moving. So on average there are 100 records per day. The unit on the vehicle calculates the mileage based on time and speed, performing calucations every ten seconds, then the mileage done within that 10 minute period is also sent. dbo.ReportingData CUSTOMERID | TRUCKID | MILEAGE What I am looking to do is run a nightly schedule for the day before, sum all the mileage in dbo.ReportingData and add it to the existing mileage within dbo.Trucks for each vehicle. Ideally I want to do this in a stored proc for all customers in the one run. How ever the only way I know how to sum one table and update the other is by using a cursor. However I have read this is resource intensive. Would anyone have any fabulous suggestions in this instance? Thanx j. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
Did you try separating out request.nextRecord? ie cfoutput#request.nextRecord#/cfoutput then you'll know if it's the index or the data -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:13 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. tw -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:10 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) yes. but im good on that... just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. that's all. tw -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 AM To: CF-Talk Subject: Re: what am I doing wrong (#'s question) cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# Don't you need an array referent for get.yournamehere[]? --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: what am I doing wrong (#'s question)
thanks dave. but I got it...it was earlier on in the code :) dummy me. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:49 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) Did you try separating out request.nextRecord? ie cfoutput#request.nextRecord#/cfoutput then you'll know if it's the index or the data -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:13 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) cfset request.nextRecord = i + 1 cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yourNameHere[i]# /option /cfif still gives me same error. so, its not the option value=0 #get.yourNameHere[i]# /option line, it's the other part. tw -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:10 AM To: CF-Talk Subject: RE: what am I doing wrong (#'s question) yes. but im good on that... just need the correct poundage for the get.companyIdNumber[request.nextRecord] to parse right. that's all. tw -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 AM To: CF-Talk Subject: Re: what am I doing wrong (#'s question) cfif get.companyIdNumber[i] eq get.companyIdNumber[request.nextRecord] option value=0 #get.yournamehere# Don't you need an array referent for get.yournamehere[]? --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
My dilemma is that I cannot have CF mail me anything as there is no mail server setup on the machine and for various reasons, we cannot set one up either, so I am kind of stuck using hand coded text log files. I ran the error handlers through the code analyzer and came up with nothing.Ran my cf templates through the analyzer as well.. No problems there. >From some deduction, I think that it may not be finished processing the first one when it attempts to CFHTTP the next in the loop and maybe thats why it getting messed up. Not sure though, as this wasn't a problem on 5.0. Maybe its erroring on the DB call since its not finished processing the first one? I have the max connections set to 10 on CFAdmin for this particular datasource. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:40 AM To: CF-Talk Subject: RE: Weird CFHTTP Error Did you try/catch/dump/mail your ERROR HANDLER?I think your handler is throwing an error. Several changes occured in MX that made code that worked in cf5 break (for example, naming variables something.something is illegal in CFMX, without first defining the structure). You might want to check your error handler for deprecated syntax. Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 A To: CF-Talk Subject: RE: Weird CFHTTP Error Maybe a little more info may help. This CFHTTP call is part of a loop over account numbers. It appears that the first loop passes CFHTTPPARAM's correctly through to the next page. It writes to my home brew log file the correct 5 variables. As it gets to the NEXT applicable one in sequence it writes this stuff in its place HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:24085 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,application/x-www-form-urlencoded,application/x-www-form-urlencode d,application/x-www-form-urlencod .etc Here is the kicker, on a CF 5.0 seperate server this cfhttp call works perfectly, now using 6.0 it doesn't seem to be working and I am getting these errors. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:29 PM To: CF-Talk Subject: RE: Weird CFHTTP Error Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
You can specify your smtp server settings yourself in the cfmail tag - specify one that is accessible, and will forward your mail to you. Incidentally, some problems can't come to light via the code analyzer until the code is run, since you COULD have defined the structure ahead of time... Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:53 A To: CF-Talk Subject: RE: Weird CFHTTP Error My dilemma is that I cannot have CF mail me anything as there is no mail server setup on the machine and for various reasons, we cannot set one up either, so I am kind of stuck using hand coded text log files. I ran the error handlers through the code analyzer and came up with nothing.Ran my cf templates through the analyzer as well.. No problems there. >From some deduction, I think that it may not be finished processing the first one when it attempts to CFHTTP the next in the loop and maybe thats why it getting messed up. Not sure though, as this wasn't a problem on 5.0. Maybe its erroring on the DB call since its not finished processing the first one? I have the max connections set to 10 on CFAdmin for this particular datasource. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:40 AM To: CF-Talk Subject: RE: Weird CFHTTP Error Did you try/catch/dump/mail your ERROR HANDLER?I think your handler is throwing an error. Several changes occured in MX that made code that worked in cf5 break (for example, naming variables something.something is illegal in CFMX, without first defining the structure). You might want to check your error handler for deprecated syntax. Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 A To: CF-Talk Subject: RE: Weird CFHTTP Error Maybe a little more info may help. This CFHTTP call is part of a loop over account numbers. It appears that the first loop passes CFHTTPPARAM's correctly through to the next page. It writes to my home brew log file the correct 5 variables. As it gets to the NEXT applicable one in sequence it writes this stuff in its place HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:24085 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,application/x-www-form-urlencoded,application/x-www-form-urlencode d,application/x-www-form-urlencod .etc Here is the kicker, on a CF 5.0 seperate server this cfhttp call works perfectly, now using 6.0 it doesn't seem to be working and I am getting these errors. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:29 PM To: CF-Talk Subject: RE: Weird CFHTTP Error Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
Additionally, you could save the content of a dump with CFFILE to anywhere you want (ie network share, etc). Point is, you need more info to troubleshoot this. -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:53 A To: CF-Talk Subject: RE: Weird CFHTTP Error My dilemma is that I cannot have CF mail me anything as there is no mail server setup on the machine and for various reasons, we cannot set one up either, so I am kind of stuck using hand coded text log files. I ran the error handlers through the code analyzer and came up with nothing.Ran my cf templates through the analyzer as well.. No problems there. >From some deduction, I think that it may not be finished processing the first one when it attempts to CFHTTP the next in the loop and maybe thats why it getting messed up. Not sure though, as this wasn't a problem on 5.0. Maybe its erroring on the DB call since its not finished processing the first one? I have the max connections set to 10 on CFAdmin for this particular datasource. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:40 AM To: CF-Talk Subject: RE: Weird CFHTTP Error Did you try/catch/dump/mail your ERROR HANDLER?I think your handler is throwing an error. Several changes occured in MX that made code that worked in cf5 break (for example, naming variables something.something is illegal in CFMX, without first defining the structure). You might want to check your error handler for deprecated syntax. Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:09 A To: CF-Talk Subject: RE: Weird CFHTTP Error Maybe a little more info may help. This CFHTTP call is part of a loop over account numbers. It appears that the first loop passes CFHTTPPARAM's correctly through to the next page. It writes to my home brew log file the correct 5 variables. As it gets to the NEXT applicable one in sequence it writes this stuff in its place HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:24085 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,application/x-www-form-urlencoded,application/x-www-form-urlencode d,application/x-www-form-urlencod .etc Here is the kicker, on a CF 5.0 seperate server this cfhttp call works perfectly, now using 6.0 it doesn't seem to be working and I am getting these errors. Jeff -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:29 PM To: CF-Talk Subject: RE: Weird CFHTTP Error Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)
Thanks for the confirmation on what I'm seeing. However, I'm a bit confused on your workaround. Are you saying that if you define the user name and password in the MX Administrator then you don't get the error? If so, that's not what I'm seeing. I define the user name and password in the MX Admin for my datasource and still see thing problem. Again though, I may be misunderstanding what you mean. Yep, that's what I'm saying. However, I'm not sure if we were seeing the _same_ error that you were seeing. (I don't actually know what our error was.) Our typical setup is that we had a single generic DSN for the oracle box, and then each developer would pass their own schema name and password from within the cfqueries. When we switched to having individual DSN's for those people that couldn't get rid of the cftransaction tags, the errors stopped. We've resorted to doing that for some apps, and moving transactional logic to stored procs for others. No fun. But, it's the only solution we've come up with so far (Oracle 8i). Yeah, I've been pushing to move our SQL, particularly the transactional queries, entirely into Oracle packages. However, I'm a one-man show as far as CF development at my company, so getting the time to refactor my inherited code base is slim to none at this point. Right there with ya. We have something like 8 GB of html and cfm code, managed by 3 full time staff and one student. Nothing gets refactored unless it's seriously broken. ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
You can specify your smtp server settings yourself in the cfmail tag - specify one that is accessible, and will forward your mail to you. Incidentally, some problems can't come to light via the code analyzer until the code is run, since you COULD have defined the structure ahead of time... Robert -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:53 A To: CF-Talk Subject: RE: Weird CFHTTP Error My dilemma is that I cannot have CF mail me anything as there is no mail server setup on the machine and for various reasons, we cannot set one up either, so I am kind of stuck using hand coded text log files. I ran the error handlers through the code analyzer and came up with nothing.Ran my cf templates through the analyzer as well.. No problems there. >From some deduction, I think that it may not be finished processing the first one when it attempts to CFHTTP the next in the loop and maybe thats why it getting messed up. Not sure though, as this wasn't a problem on 5.0. Maybe its erroring on the DB call since its not finished processing the first one? I have the max connections set to 10 on CFAdmin for this particular datasource. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running r equests...)
Interesting...they bring our servers to an immediate crashing halt with about 5 open connections to our Oracle database. We've also rolled back to the 3.1 drivers. This is what happens to us as well. I have not found anything on DataDirect's support site that relates to this problem, so I guess the next step is MM support. Unfortunately, I don't have time to get into this with them right now. The 3.1 drivers will have to suffice for a bit longer. They haven't caused us any headaches thus far. What out for this one - if you have a varchar2(4000) column, and you pass it more than 2000 characters and one of those characters happens to be a Microsoft Extended character, you will throw an error. (This may also have to do with our character set encoding, so YMMV.) (Upgrading to the 3.3 drivers would fix this, but alas, they cause much worse problems.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)
Thanks for the confirmation on what I'm seeing. However, I'm a bit confused on your workaround. Are you saying that if you define the user name and password in the MX Administrator then you don't get the error? If so, that's not what I'm seeing. I define the user name and password in the MX Admin for my datasource and still see thing problem. Again though, I may be misunderstanding what you mean. Yep, that's what I'm saying. However, I'm not sure if we were seeing the _same_ error that you were seeing. (I don't actually know what our error was.) Our typical setup is that we had a single generic DSN for the oracle box, and then each developer would pass their own schema name and password from within the cfqueries. When we switched to having individual DSN's for those people that couldn't get rid of the cftransaction tags, the errors stopped. That's an interesting setup. Alas, we only ever used the username/password features in the MX Administrator, so our environments are slightly different. I continue to see the removeOnExceptions error with just the Admin login. We've resorted to doing that for some apps, and moving transactional logic to stored procs for others. No fun. But, it's the only solution we've come up with so far (Oracle 8i). Yeah, I've been pushing to move our SQL, particularly the transactional queries, entirely into Oracle packages. However, I'm a one-man show as far as CF development at my company, so getting the time to refactor my inherited code base is slim to none at this point. Right there with ya. We have something like 8 GB of html and cfm code, managed by 3 full time staff and one student. Nothing gets refactored unless it's seriously broken. ;) Glad to know I'm not alone!! Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need SQL Advice
You could do it with something like this (this is untested!! - but you should get the idea shouldn't be too resource intensive) UPDATE trucks SET totalmileage = t.totalmileage + r.mileage FROM trucks t, (SELECT SUM(Mileage) AS mileage, TruckID FROM ReportingData GROUP BY TruckID) r WHERE t.truckid = r.truckid I'm not sure why you'd need customerID in both Trucks ReportingData - I would of thought that it should just be in Trucks? Anyway, HTH Alex -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 15:47 To: CF-Talk Subject: Need SQL Advice Hi, I need some advice here, there are two tables in a database that I am concerned with here. One is called say dbo.Trucks and the other is dbo.ReportingData. dbo.Trucks stores all the information regarding all customer trucks, customers could have one truck, others could have 50. There is a column named totalMileage [datatype float] within dbo.Trucks. dbo.Trucks table design (there is other data, but this all I am concerned with) TRUCKID | CUSTOMERID | TOTALMILEAGE dbo.ReportingData has each vehicles reporting data. A unit sends a gps report from the vehicle to our DSN every ten minutes when the vehicle is moving. So on average there are 100 records per day. The unit on the vehicle calculates the mileage based on time and speed, performing calucations every ten seconds, then the mileage done within that 10 minute period is also sent. dbo.ReportingData CUSTOMERID | TRUCKID | MILEAGE What I am looking to do is run a nightly schedule for the day before, sum all the mileage in dbo.ReportingData and add it to the existing mileage within dbo.Trucks for each vehicle. Ideally I want to do this in a stored proc for all customers in the one run. How ever the only way I know how to sum one table and update the other is by using a cursor. However I have read this is resource intensive. Would anyone have any fabulous suggestions in this instance? Thanx j. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running r equests...)
Interesting...they bring our servers to an immediate crashing halt with about 5 open connections to our Oracle database. We've also rolled back to the 3.1 drivers. This is what happens to us as well. I have not found anything on DataDirect's support site that relates to this problem, so I guess the next step is MM support. Unfortunately, I don't have time to get into this with them right now. The 3.1 drivers will have to suffice for a bit longer. They haven't caused us any headaches thus far. What out for this one - if you have a varchar2(4000) column, and you pass it more than 2000 characters and one of those characters happens to be a Microsoft Extended character, you will throw an error. (This may also have to do with our character set encoding, so YMMV.) (Upgrading to the 3.3 drivers would fix this, but alas, they cause much worse problems.) That's a good tip, as we have a few apps where our analysts cut and paste from Word docs into various textareas and save to the DB. We're using the DeMoronize() UDF, but it's seemingly not 100%, Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client Variable Overhead CFMX/CF5
Hey, Does anyone know of why a serious performance lapse between ColdFusion 5 and ColdFusion MX exists when using a Database to store Client Variables. In CF5 we found no real performance degredation from using DB over Registry. In MX when using the Registry parsing completion is around 0-16ms but when switched to a DB it can bloat to over 2000ms... This is ONLY for the cfapplication tag within an Application.cfm template. Querying the DB directly via QA has no performance lapse at all. TIA Neil This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Client Variable Overhead CFMX/CF5
Hey, Does anyone know of why a serious performance lapse between ColdFusion 5 and ColdFusion MX exists when using a Database to store Client Variables. In CF5 we found no real performance degredation from using DB over Registry. In MX when using the Registry parsing completion is around 0-16ms but when switched to a DB it can bloat to over 2000ms... This is ONLY for the cfapplication tag within an Application.cfm template. Querying the DB directly via QA has no performance lapse at all. Have you tried testing against CDATA and CGLOBAL tables with indexes on the CFID column? We did that (along with changing the column type from CHAR to VARCHAR2 (VARCHAR in SQL Server) and were able to see some nice performance gains. I know that doesn't directly answer your question, but I figured you'd might want a potential solution because there's nothing we can really do about it!! Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFCOMPONENT/CFINVOKE: Help
Help I'm using a CFC to create a Web service. One of the columns in my query past through the Web service has HTML tags in the ntext data type column.The Web Service doesn't like it and throws an error for just this column. I think the markup needs to be stripped from the data and then I think the data needs to be normalized.I woul create another table called long description and relate each record back to this original table primary id. Agree? Disagree? RECORD EXAMPLE 1: bC61/bpCombo Coupler 1/4in Series 1/4in NPT MalebrbrThe Solution for Coupler Confusion. Now One coupler Fits 1/4 Aro Style, 1/4 Automotive Standard and 1/4 Industrial Interchange Plugs. RECORD EXAMPLE 2: 'pbA750FD25/b/p pBlue Flexeel Air Hose 3/8 x 25', 1/4 MPT/p pbFeatures Benefits:/bbr /p ul liRetains flexibility in subzero temperatures/li liUV stabilized for longer outdoor service life/li liEasy to wrap store/li liResistant to lubricating oils, greases abrasion/li /ulpbFlexeelsupR/sup/b Polyurethane Reinforced Hose offers an excellent alternative to bulkier rubber hoses.It is extremely lightweight and tough.Ideal for either indoor body shop use or outsdoor road service, it keeps its flexibility even in very cold environments.Its reinforced construction eliminates the possibility of having the various layers separate due to constant expansion and contraction during pulsating operations.p RECORD EXAMPLE 3: BRNbrbrTorq Bar 13/16in-100 Ft Lb Brown [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Need SQL Advice
Thanks Alex, I'll give that a wiz. Sql requires a different mindset to programming generally as you have just proven. j. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Spam and Viruses
This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do I format Web Service results?
Hi there. I'd really appreciate any help you could provide me. How do I format my Web Service results (in my CFC?) so that I can use it with Flash dataProvider / Remoting? The NetConnection Debugger shows the results returned from my CFC as (I abbreviated it): ** Result (object #2) .__equalscalc: (undefined) .__hashcodecalc: (boolean) false .carrier: UPS .deliverydatetime: Feb 2, 2004 2:02 P.M. .deliverylocation: SANTA BARBARA, CA, US .servicetype: 2ND DAY AIR ** However, in order to use the results as a RecordSet (to bind with my DataGrid), the results that get returned to the client Flash App have to look something like: ** Result (object #2) .length: (undefined) .mRecordsAvailable: 1 .serverinfo: (undefined) .uniqueID: 1 .items (object #3) ..[0] (object #4) ...__ID__: 0 ...dlrID: DLR001 ...trackingNumber: testTRa .mTitles (object #11) ..[0]: dlrID ..[1]: trackingNumber .views (object #12) ..No properties ** Can anyone point me in the right direction? I'm trying to use the results from a UPS Web Service in my application; however, it returns multiple variables that I can't seem to get working. (My App works fine when I use a different Web Service that just returns a single string variable -- such as the current temperature.)When I trace my RecordSet results from a Web Service inquiry, I get [object Object] -- therefore, I can't use the dataProvider to bind my Results to my DataGrid. Cheers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFCOMPONENT/CFINVOKE: Help
What error are you getting exactly? You should have no problem returning a string w/ HTML in it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFCOMPONENT/CFINVOKE: Help
At 11:48 AM 5/18/2004, you wrote: Help I'm using a CFC to create a Web service. One of the columns in my query past through the Web service has HTML tags in the ntext data type column.The Web Service doesn't like it and throws an error for just this column. I think the markup needs to be stripped from the data and then I think the data needs to be normalized.I woul create another table called long description and relate each record back to this original table primary id. Agree? Disagree? You could encode the HTML text, but then you'll have to escape your entities. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Macromedia JDBC driver class names
Can anyone tell me the class name of the Macromedia JDBC driver for Oracle that is included with CFMX?I've been google searching for 20 minutes and I'm not having any luck. I'm hoping to use CFOBJECT to create a java connection object using the built in driver. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
One of the reasons you are being spammed is the way the list broadcasts emails FULLY on the webtry searching for someones in Google and you will see that you get loads of houseoffusion results with full emails to be hived off ready for spamming... No real way to stop them bar hunting down the retards who spend time setting them up etc.you could get aspamcatching engine to sit in front of your mail server (if on exchange etc) which will reduce it dramaticallyas I used to get around 200-300 per day, now you wil be lucky if I get 10 a week... _ From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 16:53 To: CF-Talk Subject: Spam and Viruses This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Client Variable Overhead CFMX/CF5
Exactly what we did...haven't seen any issues. Cheers! Stace _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:42 AM To: CF-Talk Subject: RE: Client Variable Overhead CFMX/CF5 Hey, Does anyone know of why a serious performance lapse between ColdFusion 5 and ColdFusion MX exists when using a Database to store Client Variables. In CF5 we found no real performance degredation from using DB over Registry. In MX when using the Registry parsing completion is around 0-16ms but when switched to a DB it can bloat to over 2000ms... This is ONLY for the cfapplication tag within an Application.cfm template. Querying the DB directly via QA has no performance lapse at all. Have you tried testing against CDATA and CGLOBAL tables with indexes on the CFID column? We did that (along with changing the column type from CHAR to VARCHAR2 (VARCHAR in SQL Server) and were able to see some nice performance gains. I know that doesn't directly answer your question, but I figured you'd might want a potential solution because there's nothing we can really do about it!! Regards, Dave. table width=800 cellpadding=4 cellspacing=10 border=0tr bgcolor=BDBDBDtd valign=top width=400font face=verdana size=2 color=FFbAVIS IMPORTANT/b/font/tdtd valign=top width=400font face=verdana size=2 color=FFbWARNING/b/font/td/trtrtd valign=top width=400p align=justifyfont face=verdana size=1 color=808080 Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme./tdtd valign=top width=400p align=justifyfont face=verdana size=1 color=808080 The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind./td/tr/table [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Spam and Viruses
Monique Boea wrote: This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? Doesn't stop spam/viruses, but certainly helps with the built in junk controls.http://www.mozilla.org/products/thunderbird And of course you should always have antivirus software installed on your computer that catches viruses attached to emails etc. Telling your friends that they need to install antivirus software always helps too... Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
Doesn't sound as if you have control of a mail server, so you have to go client-side. http://keir.net/k9.html You can look at Cloudmark's SpamNet.Costs $4 monthly. HtH, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Macromedia JDBC driver class names
Can anyone tell me the class name of the Macromedia JDBC driver for Oracle that is included with CFMX? I've been google searching for 20 minutes and I'm not having any luck. I'm hoping to use CFOBJECT to create a java connection object using the built in driver. You can just read it right out of neo-query.xml: macromedia.jdbc.MacromediaDriver Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Spam and Viruses
At 12:52 PM 5/18/2004, Monique Boea wrote: I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. I'm using SpamPal (www.spampal.com) and it works great.I'm down to one or two pieces of spam per day in my Inbox, and maybe one false positive every two or three days (this is due to the Bayesian filter plugin still learning my email.) T [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Macromedia JDBC driver class names
Can anyone tell me the class name of the Macromedia JDBC driver for Oracle that is included with CFMX? I've been google searching for 20 minutes and I'm not having any luck. I'm hoping to use CFOBJECT to create a java connection object using the built in driver. You can just read it right out of neo-query.xml: macromedia.jdbc.MacromediaDriver It's also in the Settings Summary page in the MX Administrator under the Data Services section (along with all the JDBC connect string information syntax, which is very useful). However, I seem to remember that somebody had posted that they get a license restriction error when trying to go against the drivers directly. But I'm not sure if they were trying to use them from a non-CF application. Anyway, just thought I'd put it out there in case you do run in to problems. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
queryparam problem
I'm trying to insert the number 1 into an int field in MSSQL 2000 but I get an Invalid data for cfsqltype cf_sql_integer error. I checked the table and it is an int 4 data type. Any idea why this would happen? Phillip B [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
You could probably whip up a quick VB COM object to run server side that uses the Printers object.Quickest way would be to use something like cf_pdf to create an unencrypted PDF file, then use some combination of acrobat/ghostscript to dump it to the printer you want. A great book for learning VB Com objects is Visual Basic Objects by John Smiley.One chapter of it was worth the entire price of the book for me. Best of luck, J 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 the web site owners offices or on his intranet?If not, is the web site owners printer exposed to the internet?(...bad idea!) If there is no direct access by CF to the web site owners network perhaps some work around where CF writes files to an ftp directory and then some process runs in the web site owners offices (a delphi or vb program or script or some other windows routine), that is busyreading that ftp directory and downloads and prints the forms... doable yes... practical... that depends upon the value of the information in the form. At 11:24 AM 5/10/04, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Reporting Tools
Is there any reason you couldn't use the crystal java report viewer to open run the report off the server?It works quite well, and could save you some time and headache if you have reports already made. -J Upgrade to SQL2K and download/get SQL Reporting Tools - very very good and free. _ From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 12:56 To: CF-Talk Subject: Reporting Tools I have a need to produce some simple reports using Cold Fusion. They are simple, text only reports, but I must have control over page layout, the ability to put row headers and the like on every page,etc. Currently, we have a VB app that generates these reports using Crystal on an Access database, but I'd like to generate the reports on the web server using a web service, and produce a link to the generated report. I'm looking at one open source tool called jasper reports (http://jasperreports.sourceforge.net) that looks like it has potential. I wondered if anyone has successfully integrated this particular solution? Any other suggestions? Thanks. Rick Root _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Spam and Viruses
If you control you own mail server - we can provide an anti-spam and anti-virus gateway which will forward clean mail to your server.The only configuration required is a simple one line addition to your MX records. == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message - From: Monique Boea To: CF-Talk Sent: Tuesday, May 18, 2004 10:52 AM Subject: Spam and Viruses This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia JDBC driver class names
Thanks for everyone's help.. with a little help from the datadirect documentation, I was actually able to get the following to work: cfscript clazz = CreateObject(java, java.lang.Class); // replace the package/class name of your db driver clazz.forName(macromedia.jdbc.MacromediaDriver); driverManager = CreateObject(java, java.sql.DriverManager); // replace w/ your server, database name, username password conurl = jdbc:macromedia:oracle://:1521;SID=*;user=*;password=*; connection = driverManager.getConnection(conurl); query = DELETE FROM IDS WHERE ID=1; preparedStatement = connection.prepareStatement(query); result = preparedStatement.executeUpdate(); WriteOutput(result = result); connection.close(); /cfscript For what it's worth, this is the second time I've resorted to using the datadirect documentation to solve a driver-related issue with Cold Fusion :) - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Another way you could look at this is to check for the length of the total characters in the first line. If it will never be less than 4, then you could wrap it with a conditional statement to check until it finds the first real line that is longer than 4 characters. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. If you're using Outlook, SpamBeyes is working well for me after training it up http://spambayes.sourceforge.net/ -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Macromedia JDBC driver class names
For what it's worth, this is the second time I've resorted to using the datadirect documentation to solve a driver-related issue with Cold Fusion :) Out of curiosity, what exactly are you trying to accomplish in Java that you can't do directly from CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia JDBC driver class names
Thanks for everyone's help.. with a little help from the datadirect documentation, I was actually able to get the following to work: cfscript clazz = CreateObject(java, java.lang.Class); // replace the package/class name of your db driver clazz.forName(macromedia.jdbc.MacromediaDriver); driverManager = CreateObject(java, java.sql.DriverManager); // replace w/ your server, database name, username password conurl = jdbc:macromedia:oracle://:1521;SID=*;user=*;password=*; connection = driverManager.getConnection(conurl); query = DELETE FROM IDS WHERE ID=1; preparedStatement = connection.prepareStatement(query); result = preparedStatement.executeUpdate(); WriteOutput(result = result); connection.close(); /cfscript For what it's worth, this is the second time I've resorted to using the datadirect documentation to solve a driver-related issue with Cold Fusion :) Rick, perhaps I missed it, but what issue did you run into with the drivers that you needed to resort to this? Your query looks to be pretty basic. Just curious. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Reporting Tools
Jas Panesar wrote: Is there any reason you couldn't use the crystal java report viewer to open run the report off the server?It works quite well, and could save you some time and headache if you have reports already made. Are you referring to the built in CFREPORT functionality?That may work, but there's ZERO documentation on it in the CFMX Developer's Guide, and the Language Reference isn't much help either. Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryparam problem
if you have quotes around '1', remove them -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 12:18 PM To: CF-Talk Subject: queryparam problem I'm trying to insert the number 1 into an int field in MSSQL 2000 but I get an Invalid data for cfsqltype cf_sql_integer error. I checked the table and it is an int 4 data type. Any idea why this would happen? Phillip B [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia JDBC driver class names
Dave Watts wrote: Out of curiosity, what exactly are you trying to accomplish in Java that you can't do directly from CF? My goal is to build a web service that uses JasperReports, a free Java report generation tool, to generate reports in PDF format and return a link to the generated report for viewing and printing. One of the requirements is that I pass a connection object as a parameter to the JasperManager.fillReport() method.Unfortunately, connections created in Cold Fusion are apparently not available to Java, so I must create the connection object using Java, THEN pass it to the fillReport method. Ultimately, this web service will be consumed by a VB app that already exists. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia JDBC driver class names
Dave Carabetta wrote: Rick, perhaps I missed it, but what issue did you run into with the drivers that you needed to resort to this? Your query looks to be pretty basic. I've explained the real reasoning in another post.. but the ALLEGED reason for running a query this way is that CFQUERY won't return any results for a DELETE Query.How many rows were deleted? When you use this method, you get that information. Presumably, it works with update statements as well. I got the original idea from THIS blog entry by Aaron Johnson: http://cephas.net/blog/2004/05/10/coldfusion_mx_and_javasql.html - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Script to redirect output from STDERR to STDOUT
This script will run the specified command on a Unix or Linux operating system.The script redirects output from STDERR to STDOUT to allow ColdFusionMX to make error messages available to the cfexecute tag.These error messages can be captured in the variable parameter or output to a file. #--Perl Script--- #Run command with the supplied parameters and print the result to STDOUT print [EMAIL PROTECTED] 21`; [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia JDBC driver class names
Rick, perhaps I missed it, but what issue did you run into with the drivers that you needed to resort to this? Your query looks to be pretty basic. I've explained the real reasoning in another post.. but the ALLEGED reason for running a query this way is that CFQUERY won't return any results for a DELETE Query.How many rows were deleted? When you use this method, you get that information. Presumably, it works with update statements as well. I got the original idea from THIS blog entry by Aaron Johnson: http://cephas.net/blog/2004/05/10/coldfusion_mx_and_javasql.html I had seen this blog entry as well. Glad to know that it works. I may have a use for it elsewhere as well. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: RE: Spam and Viruses
Perhaps a bit off-topic, but sort of along the same lines - anyone figure out how to handle spoofed bouncebacks from anti-virus protected email accounts? I believe I'm getting more of those than actual spam or virus messages these days. You'd think the mail servers would assume the virus is coming from a spoofed email address. *sigh* Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 9:40 AM To: CF-Talk Subject: RE: Spam and Viruses I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. If you're using Outlook, SpamBeyes is working well for me after training it up http://spambayes.sourceforge.net/ -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Memory Consumption
This is kind of a general question regarding CFMX and how it utilizes memory. I know in CF 5 CF will consume the amount of memory it needs and then hold onto it and reallocate it back and forth. How does CFMX handle memory, the same way? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
No I don't mean on this email address...I mean another one... Nothing to do with this email list -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:56 AM To: CF-Talk Subject: RE: Spam and Viruses One of the reasons you are being spammed is the way the list broadcasts emails FULLY on the webtry searching for someones in Google and you will see that you get loads of houseoffusion results with full emails to be hived off ready for spamming... No real way to stop them bar hunting down the retards who spend time setting them up etc.you could get aspamcatching engine to sit in front of your mail server (if on exchange etc) which will reduce it dramaticallyas I used to get around 200-300 per day, now you wil be lucky if I get 10 a week... _ From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 16:53 To: CF-Talk Subject: Spam and Viruses This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
At 02:08 PM 5/18/2004, Monique Boea wrote: One of the reasons you are being spammed is the way the list broadcasts emails FULLY on the webtry searching for someones in Google and you will see that you get loads of houseoffusion results with full emails to be hived off ready for spamming... I just tried that - [EMAIL PROTECTED] comes up with no hits on Google.Nor does [EMAIL PROTECTED]I don't think she's getting spam that way. T [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
At 02:25 PM 5/18/2004, Thane Sherrington wrote: I just tried that - [EMAIL PROTECTED] comes up with no hits on Google.Nor does [EMAIL PROTECTED]I don't think she's getting spam that way. I take it back - [EMAIL PROTECTED] comes up with a lot of hits.So maybe some spam is coming through that way. T [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
General CFMX Tuning Recommendations
I know it's been brought up before in different places concerning different subjects, but I'm curious if anyone has any input on CFMX Production Server tuning with the following specs: Windows 2003 Server Enterprise CFMX 6.1 1GB RAM 40+ GB of hard drive space for websites P4 2.8Ghz We're hosting between 10-15 different CF sites now and will be adding an additional 10-20 this year.I'm curious as to what performance settings I should set, especially in the CF Admin with regards to simultaneous requests, caching, etc.Any suggestions or insights would be appreciated. Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
the address is [EMAIL PROTECTED] -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 1:28 PM To: CF-Talk Subject: RE: Spam and Viruses At 02:25 PM 5/18/2004, Thane Sherrington wrote: I just tried that - [EMAIL PROTECTED] comes up with no hits on Google.Nor does [EMAIL PROTECTED]I don't think she's getting spam that way. I take it back - [EMAIL PROTECTED] comes up with a lot of hits.So maybe some spam is coming through that way. T _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Memory Consumption
To really understand CFMX's memory handling, you have to understand the Java memory model. I'm no super-java-pro, but here's my understanding. Basically, everything in Java is an object. Objects are created and stored on the heap. Garbage collection (gc) runs when it needs to (and for various reasons) and kills off any dis-associated objects. For instance, an http request creates an object on the J2EE server (typically for CFMX, that's JRun), once it runs and HTML is returned to the browser (or whatever it does), the object is no longer in use. This request is now dead memory on the heap, and Java's gc comes through and removes it. There ya go, memory used, memory returned to the system. -nathan strutz Robert Shaw wrote: This is kind of a general question regarding CFMX and how it utilizes memory. I know in CF 5 CF will consume the amount of memory it needs and then hold onto it and reallocate it back and forth. How does CFMX handle memory, the same way? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Reporting Tools
CFREPORT could concievably work very well too -- it would only generate the report and drop it to a specified file.Have you tried the examples provided from CF 4.5+ documentation to use cfreport? if all else fails, google +cfreport +example without the quotes.I was referring to a activex/java based report viewer that embeds into th web browser that allows u to run and view reports right in the browser.You can find more info about on the devzone at: http://www.businessobjects.com/services/support/default.asp Gluck, Jas Are you referring to the built in CFREPORT functionality?That may work, but there's ZERO documentation on it in the CFMX Developer's Guide, and the Language Reference isn't much help either. Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue [ SOLVED ]
When installing CFMX on Win2003, make sure that the ISAPI filter URLScan is disabled or it will intercept all the _javascript_ing commands that need to be run to complete the installation. happy camper now. == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[OT] Select + in combo, open popup, save in DB, reload main select...
Hi all sorry for OT. please help me... I'm looking for anythink about how to... 1) user clicks in Add City if Combo(SELECT field) don't have your city. Open popup. 2) Insert your city in popup to DB. 3) close popup. 4) reload only original select...combo... Find several articles about DIV, IFRAME, Remote Scripting but nothing fit our needs... Do you can help me? Thanx for your time... -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFCOMPONENT/CFINVOKE: Help
What error are you getting exactly? You should have no problem returning a
string w/ HTML in it.
Error Occurred While Processing Request
Could not perform web service invocation myFunction because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: org.xml.sax.SAXParseException: Illegal XML character: amp;#x1d;. faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: org.xml.sax.SAXParseException: Illegal XML character: amp;#x1d;. at org.apache.crimson.parser.InputEntity.fatal(InputEntity.java:1100) at org.apache.crimson.parser.InputEntity.parsedContent(InputEntity.java:593) at org.apache.crimson.parser.Parser2.content(Parser2.java:1973) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at org.apache.crimson.parser.Parser2.maybeElement(Par...
The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\Web_Services\Inventory_test.cfm: line 14
12 :webservice=http://www.toolweb.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl
13 :method=myFunction
14 :returnvariable=aQuery
15 : /cfinvoke
16 :
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
