OT: java web services
Hi, Can anyone recommend a good forum/mailing list or point me to some good examples for help and advice regarding developing and consuming web services with java? The problem I'm specifically having is how to call a web service (in java) which returns an array of java objects. TIA, Alex ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: recordsets return by stored procedures?
Assuming that each recordset you're returning has something that could uniquely identify it (eg a productID), I would probably return just 1 recordset, with all the data that you were returning via multiple recordsets combined - just add the ID number. Then when you're outputting or processing, just use the group attribute of cfoutput, or use QoQ. HTH, Alex -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 16:07 To: CF-Talk Subject: recordsets return by stored procedures? Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Web services caching
Hi, I'm trying to create some web services (fairly simple stuff for now - taking an integer as input and returning a string) but am coming up against a few irritating problems that hopefully someone can help with (on CF6.1): 1. If I add a new cffunction to an existing component then it doesn't appear to be recognised - the calling page (another server also running CF6.1) returns a message saying that the function with the parameters cannot be found. 2. If I create a new component file when I try and call it I sometimes (not always!) get the message: Could not generate stub objects for web service invocation 3. Don't seem to be able to create functions which have no arguments at all - just get a message saying the functions with the parameters cannot be found. Is any of this to do with the component being cached? (I've not set up any caching - so would only be what is set up by default in CF) - or does anyone have any other suggestions? I've included some sample code below. Any help much appreciated, Alex - Code: Testservice.cfc: cfcomponent cffunction name=TestService access=remote returntype=string !--- return the string --- cfreturn Here is a web service called TestService /cffunction /cfcomponent Calling code: cfinvoke webservice=http://dev-iet.open.ac.uk/webservices/testservice.cfc?WSDL; method=TestService returnvariable=testing /cfinvoke cfoutput#testing#/cfoutput ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web services caching
Hi Thanks for this - I've now got all 3 of these problems solved with clearing the web service from the client server. My understanding of the purpose of this section on the CF admin was completely the wrong way round - I thought it was for the web services that the particular CF server provides, not consumed! It's all beginning to make a bit more sense now ;-) Alex -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2005 12:56 To: CF-Talk Subject: RE: Web services caching I'm not sure about all of these, but: 1. Try going to the CF administrator on the client server and refreshing the web service where you added the function. You used to have to delete a file on the OS when this happened, but now I think you can do it from the CF admin site. 2. Does it ever finally work or does it never work on that particular CFC? Are you trying to use a CFC with the same name as a CFC that *used* to exist? 3. Not sure here. -Original Message- From: A.Little [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 6:00 AM To: CF-Talk Subject: Web services caching Hi, I'm trying to create some web services (fairly simple stuff for now - taking an integer as input and returning a string) but am coming up against a few irritating problems that hopefully someone can help with (on CF6.1): 1. If I add a new cffunction to an existing component then it doesn't appear to be recognised - the calling page (another server also running CF6.1) returns a message saying that the function with the parameters cannot be found. 2. If I create a new component file when I try and call it I sometimes (not always!) get the message: Could not generate stub objects for web service invocation 3. Don't seem to be able to create functions which have no arguments at all - just get a message saying the functions with the parameters cannot be found. Is any of this to do with the component being cached? (I've not set up any caching - so would only be what is set up by default in CF) - or does anyone have any other suggestions? I've included some sample code below. Any help much appreciated, Alex - Code: Testservice.cfc: cfcomponent cffunction name=TestService access=remote returntype=string !--- return the string --- cfreturn Here is a web service called TestService /cffunction /cfcomponent Calling code: cfinvoke webservice=http://dev-iet.open.ac.uk/webservices/testservice.cfc?WSDL; method=TestService returnvariable=testing /cfinvoke cfoutput#testing#/cfoutput ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Wierd ValueList() Issue
Is each server using the same database? - as it could be because one database is returning 1/0 and the other true/false for bit fields AFAIK (and I could well be wrong!) the valuelist() function just takes whatever is in the column and it doesn't try and interpret the column types. If both servers are calling on the same database that kinda blows my theory!! - but you could just get around the problem by using if columnvalue instead of if columnvalue EQ 1 HTH Alex -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 10 March 2005 12:38 To: CF-Talk Subject: Wierd ValueList() Issue OK, I have a query which is bringing back a column containing BIT values. On one server when I perform a ValueList() on the column to evaluate its value to the actual (1,0) value it will work fine but on another the same function and same query will not work as ValueList() seems to be converting the 1 and 0s into the words TRUE and FALSE. i.e. this pseudo works on one server but not other: if columnvalue EQ 1 as the offending server is treating columnvalue a TRUE even though the query contains 1? It really doesn't make sense. Any ideas? Both servers are running the same version of CF / Patches and the same JVM. N 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198170 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Web Accessibility
Hi, Does anyone out there know of any tools/services that I can integrate with out web publishing system that will check the page content (entered by users) against web accessibility guidelines (WAI/s508/SENDA) before we allow it to be published to the live site. I know about the Bobby, LIFT other tools that you can manually run or cfhttp to, but I'd like something where I can integrate the resulting report in my CF application. Ideally what I'm looking for is a webservice that accepts either a URL or the actual content (preview of the page) and will return an xml string for the accessibility errors and warnings which I can then display back to our users. Any help/advice appreciated, or any other suggestions as to other ways I could go about this. Alex ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Error consuming web services
OK, I must be doing something really dumb here... I run this following
code:
cfinvoke
webservice=http://dev-iet.open.ac.uk/webservices/people.cfc?wsdl;
method=getPeople
returnvariable=testing
cfinvokeargument name=GroupID value=15/
/cfinvoke
cfoutput#testing#/cfoutput
To call the webservice code:
cfcomponent
cffunction name=getPeople access=remote
returntype=string
cfargument name=GroupID type=numeric
required=yes
cfset returnXML = my xml string will be here
cfreturn returnXML
/cffunction
/cfcomponent
(and this appears fine as wsdl when I go to
http://dev-iet.open.ac.uk/webservices/people.cfc?wsdl)
But I get the error Web service operation getPeople with parameters
{GroupID={15},} could not be found.
So - what have I done wrong?! For info the webservice is on CFMX (6.1)
and the calling code is on CF7
Alex
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195151
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: a distinct sql problem....
You could, rather than select the whole date field (which will probably includes the time? hence why the row is shown as not distinct) select the year(date), month(date), day(date) then the only way you'll get 2 candidate ids is if one candidate id has two entries for one given day. Or you could group if by month/year/whatever. If you don't select the date in some form like this, the database can't know which date it should extract for a given (distinct) candidate id HTH Alex -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 15 February 2005 14:58 To: CF-Talk Subject: Re: a distinct sql problem the only problem is that I need that date object as well. Unless I do 2 queries and then perform some kind of checking and throw the final results into a structure. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Web Services - getting confused!
Hi,
I'm playing around with creating a couple of simple web services, but as
soon as I add more than one function to a component, I seem unable to
invoke the second function and get the error message 'Web service
operation myDocTitle with parameters {5024} could not be found. ' but
it works fine if I invoke the first function I created getDocTitle.
I've tried cycling the CF service and removing the webservice from CF
admin but nothing seems to work.
What am I missing ?!!
Any help would be much appreciated (code snippets below),
Alex
For info the cfc code is:
cfcomponent
cffunction name=getDocTitle access=remote returntype=string
cfargument name=DocumentID type=numeric
required=yes
cfquery name=qry_getDoc datasource=#request.dsn#
SELECT DocumentTitle FROM tblDocument
WHERE DocumentID = cfqueryparam
cfsqltype=cf_sql_integer value=#arguments.DocumentID#
/cfquery
cfreturn testing: qry_getDoc.DocumentTitle
/cffunction
cffunction name=myDocTitle access=remote returntype=string
cfargument name=DocumentID type=numeric
required=yes
cfquery name=qry_getDoc datasource=#request.dsn#
SELECT DocumentTitle FROM tblDocument
WHERE DocumentID = 5024
/cfquery
cfreturn qry_getDoc.DocumentTitle
/cffunction
/cfcomponent
And the invoking code is:
cfscript
DocumentID = 5024;
ws =
createobject(webservice,http://kn-dev.open.ac.uk/testarea/webservice/
document.cfc?wsdl);
testvar = ws.myDocTitle(DocumentID);
/cfscript
cfoutput#testvar#/cfoutput
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Web Services - getting confused!
It does return valid wdsl, however the wsdl doesn't appear to have any of the elements/details for the myDocTitle function, only the getDocTitle function. I'll have a go with an even simpler service (as you suggest) and see what happens. Alex -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 27 May 2004 14:38 To: CF-Talk Subject: RE: Web Services - getting confused! Hi Alex, Looks fine to me, and it works fine if I copy and paste the code on my server - if you put the wsdl url into your browser, does it return a valid wsdl? Is the myDocTitle function defined in it? Does it work if you change the functions to just return a hard-coded variable, instead of a query? Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [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]
Caching problem?
Hi all, We're in the process of developing a new site which is very similar to a previous site we've built, so we copied the webroot and customtags to new folders and renamed the customtags (and references to them within the code). Now we've mapped the dev domain name to the webroot, so we have kn-dev.open.ac.uk and krn-dev.open.ac.uk. We seem to be getting a problem where if we restart the server and visit kn-dev.open.ac.uk/index.cfm and then go to the page krn-dev.open.ac.uk/index.cfm the KRN version picks up the header file from KN, similarly if we go to krn-dev.open.ac.uk/index.cfm first and then kn-dev.open.ac.uk/index.cfm the KN version picks up the KRN version. (We've updated the KRN header file with a different design to KN). We've tried a number of things including; - adding a cfheader no-cache to stop the client caching the page - rebooting the server - clearing the compiled java classes - adding cfcache action="" to each index page However none of these seem to be working. So does anyone have any other suggestions as to what we could try? Unfortunately it's all behind a firewall so you won't be able to view the problem - but this is not an april fool!! ;-) TIA Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Caching problem?
Thanks, we're not using CF mappings, and we're not using application or session scope - we're using the request scope and client vars. I;ve checked that the Application.cfm has a different app name - although the client variable store datasource is the same, but I can't see why this would make any difference. We've got the file structure as follows: D:\wwwroot\ - this is for kn-dev.open.ac.uk D:\wwwroot\workspace\krn\ for krn-dev.open.ac.uk And the KRN site has it's own Application.cfm but the krn-dev.open.ac.uk is picking up the d:\wwwroot\index.cfm if the kn-dev.open.ac.uk has been viewed first. I;ve set up a number of sites on another server in exactly the same way (still w2k IIS5) and these work fine. Any other ideas? Alex -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 01 April 2004 12:23 To: CF-Talk Subject: RE: Caching problem? Are you using CF mappings? If you didn't change those it will include the files from the previous site when you use them. Are you using the application and session scope to store info? Be sure to change the name attribute of cfapplication Pascal -Original Message- From: A.Little [mailto:[EMAIL PROTECTED] Sent: donderdag 1 april 2004 10:34 To: CF-Talk Subject: Caching problem? Hi all, We're in the process of developing a new site which is very similar to a previous site we've built, so we copied the webroot and customtags to new folders and renamed the customtags (and references to them within the code). Now we've mapped the dev domain name to the webroot, so we have kn-dev.open.ac.uk and krn-dev.open.ac.uk. We seem to be getting a problem where if we restart the server and visit kn-dev.open.ac.uk/index.cfm and then go to the page krn-dev.open.ac.uk/index.cfm the KRN version picks up the header file from KN, similarly if we go to krn-dev.open.ac.uk/index.cfm first and then kn-dev.open.ac.uk/index.cfm the KN version picks up the KRN version. (We've updated the KRN header file with a different design to KN). We've tried a number of things including; - adding a cfheader no-cache to stop the client caching the page - rebooting the server - clearing the compiled java classes - adding cfcache action="" to each index page However none of these seem to be working. So does anyone have any other suggestions as to what we could try? Unfortunately it's all behind a firewall so you won't be able to view the problem - but this is not an april fool!! ;-) TIA Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Redirect cferror
Hi all, We're in the process of combining our dept focussed intranet (iet-only) and institution focussed intranet (iet-ou) into a single intranet (iet-intranet) and I'm trying to figure out the best way to redirect users who go to iet-only or iet-ou to the new site (as most of the pages will be in exactly the same structure). So far I've got a custom 404 message for the iet-only and iet-ou sites (which point to adirectory that contains only the redirect page and Application.cfm) and redirects to the new iet-intranet. This seems to work fine for everything except .cfm files which give the CF-type template not found error. I've tried using a cferror tag on the Application.cfm to trap this, but it still seems to fail. We need the redirect to work for any type of file, .doc, .pdf, .pps etc - not just cfm files. How can I trap a missing template (rather that missing include) using cferror? I don't want to use the CF-admin sitewide handler because there are other sites on the instance of CF which we do not want to use the same missing template file. Or any other suggestions/advice on how to achieve this would be appreciated. I;ve also tried to look for a cgi script to intercept the requests and change the domain name as they arrive at the web server - but I;ve not found a suitable script (yet!). Ta, Alex (btw we're using IIS5 W2K) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Redirect cferror
Thanks Pascal - I did look at doing this but the custom 404 page I've got is a cfm template so if I removed the .cfm filters then the redirect wouldn't work... Alex -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:55 To: CF-Talk Subject: RE: Redirect cferror Alex, I'm no webserver expert, but can't you just remove the .cfm and .dbm filters from the application settings of the old site in IIS. I think cf will no longer treat the request then and you will be redirected in the same way as for the other files Pascal -Original Message- From: A.Little [mailto:[EMAIL PROTECTED] Sent: dinsdag 23 maart 2004 12:39 To: CF-Talk Subject: Redirect cferror Hi all, We're in the process of combining our dept focussed intranet (iet-only) and institution focussed intranet (iet-ou) into a single intranet (iet-intranet) and I'm trying to figure out the best way to redirect users who go to iet-only or iet-ou to the new site (as most of the pages will be in exactly the same structure). So far I've got a custom 404 message for the iet-only and iet-ou sites (which point to adirectory that contains only the redirect page and Application.cfm) and redirects to the new iet-intranet. This seems to work fine for everything except .cfm files which give the CF-type template not found error. I've tried using a cferror tag on the Application.cfm to trap this, but it still seems to fail. We need the redirect to work for any type of file, .doc, .pdf, .pps etc - not just cfm files. How can I trap a missing template (rather that missing include) using cferror? I don't want to use the CF-admin sitewide handler because there are other sites on the instance of CF which we do not want to use the same missing template file. Or any other suggestions/advice on how to achieve this would be appreciated. I;ve also tried to look for a cgi script to intercept the requests and change the domain name as they arrive at the web server - but I;ve not found a suitable script (yet!). Ta, Alex (btw we're using IIS5 W2K) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: Redirect cferror
Cheers Mike - that's what I needed ;-) Alex -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 12:08 To: CF-Talk Subject: RE: Redirect cferror in iis make sure the for .cfm extensions it checks for the existance of the file, that way it will then trigger the custom 404 HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: wysiwyg Editor for Macs
Kelly, Just out of interest, what have you found to be problematic with eWebWP? I'm asking because we're looking at using this tool too, but it would be handy to know the experiences from someone who's used it in 'real life' ;-) Ta, Alex Ps. Feel free to email me off list if it goes a bit OT. -Original Message- From: Kelly Tetterton [mailto:[EMAIL PROTECTED] Sent: 03 March 2004 13:35 To: CF-Talk Subject: RE: wysiwyg Editor for Macs Check out Ektron's eWebWP. It's not perfect, by any means, but it's written in flash and we've used it successfully with Mac clients -- -Original Message- From: Daniel Pacitti - ASP [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 4:45 AM To: CF-Talk Subject: wysiwyg Editor for Macs Does anyone know of a good wysiwyg editor that is compatable for a Mac that can be used in an html form??We are currently using ActivEdit 3 from cfdev, but this does not work in a mac environment. Daniel Pacitti Developer ASP Multimedia Limited T: +44 (0)20 8603 5673 F: +44 (0)20 8686 7911 www.aspevents.net ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DateDiff being a bit weird.....
Hi all,
Am I going mad or is there something I'm missing If I run the
following code:
cfloop from=0 to=5 index=i
cfset tempdate=dateadd('d',i,'26-mar-2004')
cfset temp2 = '31-mar-2004'
#i#: #tempdate# to #temp2#: #datediff('d',tempdate,temp2)#br
/cfloop
I get the following output:
0: {ts '2004-03-26 00:00:00'} to 31-mar-2004: 4
1: {ts '2004-03-27 00:00:00'} to 31-mar-2004: 3
2: {ts '2004-03-28 00:00:00'} to 31-mar-2004: 2
3: {ts '2004-03-29 00:00:00'} to 31-mar-2004: 2
4: {ts '2004-03-30 00:00:00'} to 31-mar-2004: 1
5: {ts '2004-03-31 00:00:00'} to 31-mar-2004: 0
So my question is: why is the difference the same between
28-mar-2004/31-mar-2004 as it is for 29-mar-2004/31-mar-2004, ie 2 days?
Any help would be much appreciated...
Alex
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFHeader/CFContent woes.
Hi, Not sure if this will help but I noticed in my cfheader/cfcontent code that I had double quotes around the filename in the value attribute of the cfheader tageg value=inline; filename=myfilename.doc HTH Alex | -Original Message- | From: Shawn Grover [mailto:[EMAIL PROTECTED] | Sent: Saturday, January 10, 2004 23:07 | To: CF-Talk | Subject: CFHeader/CFContent woes. | | I know this is a relatively common question on the list, but the | common answers/solutions just aren't working for me. | | I've built a testing page to isolate my problem with the following | code: | | CFHEADER NAME=Content-Disposition VALUE=attachment; | filename=fax_tenant.doc cfcontent type=application/msword | file=c:\inetpub\wwwroot\app\fax_tenant.doc deletefile=No | | The problem is that no matter what I do to the cfheader line, I NEVER | see fax_tenant.doc as the requested filename.I see the name of the | .cfm file (which is word_test.cfm in this case).I wouldn't really | care if the thing would at least display or save the word file. | | I've tried changing the cfheader line to read VALUE=inline; | filename=fax_tenant.doc, and VALUE=filename=fax_tenant.doc | - both had absolutely no effect. | I've blew away my browser and server cache, and the compliled java | classes for the page, and still saw no difference. I've tested this on | two other workstations, and they saw the same behavior. | So it's not workstation specific. | | I'm stumped.I have another application on the same server that does | the same two lines (with application specific values of course), and | it runs fine. | | Can anyone tell me what I'm doing wrong?The server is CFMX 6.0, and | an upgrade to 6.1 is not an option at this time. | | Shawn | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Random scheduled page
You could set up a scheduled task to run at say 7am, all this task would do would be to generate the random time between 8 and 10am and then update the actual task using cfschedule to next run at the time that has just been generated. Alex -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 14:43 To: CF-Talk Subject: Random scheduled page I need to have a CF page run at a random time between 8 and 10 a.m. once a day. Any suggestions on how to do this? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ever growing single quotes (')
Yes, we've had that too, the solution we found was to use:
cfqueryparam cfsqltype=...
value=#preservesinglequotes(form.variable)#
Doesn;t help for all those records where theres already a load of single
quotes - but it should be easy enough to write an update query to get
rid of those.
Alex
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 10 December 2003 03:18
To: CF-Talk
Subject: Ever growing single quotes (')
Has anybody ever experienced a problem, where if you update a
string in a SQL 2000 database with a cfqueryparam tag, each time the
string is updated, an additional single quote is appended to each single
quote in the string?
Start with the string
I'll just run to the store and get some milk.
Update it once and you get
I''ll just run .
Update it a second time you get
Ill just run
After not too many reputations of this, you can get an a
awefully long series of single quotes.
I can't see anyplace where this is obviouslly happening.The
form that contains the string doesn't show the new quotes, but it will
show the quotes the next time the record in viewed.
___
Ian Skinner
Web Developer
Sierra Outdoor Recreation
(http://www.SierraOutdoorRecreation.com)
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[OT] - RegExp Help
Hi all,
I'm trying to write a regular _expression_ and am having a little
trouble... What I want to do is replace all instances of '/document.cfm'
in a string with '/public/document.cfm', unless the original substring
is '/public/document.cfm' - ie I don't want to end up with
'/public/public/document.cfm'.
This is what I;ve been trying:
#ReReplace('.open.ac.uk/document.cfmtest','(^public)/document.cfm','/pu
blic/document.cfm')#
But in this instance it's not finding a match, so not replacing the
required substring - can anyone give me any pointers as to where I;ve
gone wrong? I found plenty of examples about Reg Exp generally, but none
which seem to fit what I'm trying to achieve.
Thanks,
Alex
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: SQL to Access
Your best bet (I think) would be to use the SQL server Data Transformation Service. This will allow you to export tables/views etc to access quite easily. Just go into SQL Ent Manager and export the required tables to Access, and if you need to regularly dump the data out, you can save the export process as a package, then set up a scheduled job to run the package. HTH Alex -Original Message- From: Danielle Romain [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 02:42 To: CF-Talk Subject: SQL to Access The project that I am working on requires dumping data from SQL Server into a table in Microsoft Access.I am currently using a stored proc to fetch the needed information from SQL then looping through each row in the returned query in order to populate the Access data table. I'm concerned that this solution will be too slow for use in production. Any ideas??? You're help would be appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Learning CSS
Here's another one to help get you started http://www.w3schools.com/css/default.asp Alex -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED] Sent: 27 November 2003 19:26 To: CF-Talk Subject: Learning CSS I am just realizing the power of CSS, but am also aware I know precious little about how CSS works or what the best practices are regarding it's use.So...I am wondering if anyone could point me to a good reference and/or book to learn from?Any advice? Thanks very much, John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sleepy CF
It might to do with the CF templates being compiled. After a template has been amended (or after CF has been restarted on the server) CF needs to recompile the template, hence why it can be much slower on the first 'hit' than the subsequent hits. This was a bit of a problem for doing development with the first version of CFMX, but I thought that 6.1 had speeded up the compiling process. HTH Alex -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 21:27 To: CF-Talk Subject: Sleepy CF I've got a 6.1 box on the LAN and it takes long time to get the first page after I haven't hit the site in a while, the following pages spool much faster. I haven't nailed down the threshold for this behavior, but is there anything I should look at? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Licensing for applications developed in CF
Hi all, We've been approached by a couple of other Universities who are interested in using one of our applications developed in CF. We would be providing them, for free, with a non-encrypted copy of our CF code and database schema script, so they would be able to develop the application and adapt it for their own needs. So we'd be providing them with an as-much-as-a-cf-app-can-be open source application. Our little problem has been tracking down a licensing agreement which we could provide the other universities with, which covers the above distribution model. We haven't, as yet, formally decided whether they would be able to distribute the modified code, but I think the decision is going to allow them to distribute any modified code. I've had a look through the GNU General Public License and it mainly seems to fit the bill, but I'm unsure of whether the fact that the app requires CF to run would invalidate the license. Can anyone point me in the right direction or have any experience/advice they can provide? Any help would be much appreciated, Alex Little [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Extract Domain and scriptname seperate
You could treat the form field as a list delimited by '/', then you'll have the first 2 list elements will give the protocol and the domain name, and the remaining list elements would give you the script name and query string... something like: cfset domain_part = listgetat(form.myurl,1,'/') '//' listgetat(form.myurl,2,'/') cfset form.myurl = listdeleteat(form.myurl,1,'/') cfset form.myurl = listdeleteat(form.myurl,1,'/') cfset script_and_query_part = '/' form.myurl or you could look at using a regular _expression_. Alex -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: 01 October 2003 12:34 To: CF-Talk Subject: RE: Extract Domain and scriptname seperate Hi, In my case I have a form where people submit a URL and on post I have to extract this into pieces. Ketan Patel G3 Technology Group, LLC Graphics III Advertising, Inc. (410)789-7007 or (800)783-1799 It's Not Creative if it doesn't Sell. http://www.g3group.com http://www.g3group.comhttp://www.g3group.com http://www.g3group.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Combining Form Fields ?
It usually best not to store data like this in one field though, rather store it in the 3 seperate fields and combine them in the query when you extract the data from the database or in your application. You may find in the future that you need to get 'Mr Smith' rather than 'Mr John Smith' from the database, and this can be a right pain if you're storing all the data in one field. HTH Alex -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 30 September 2003 15:30 To: CF-Talk Subject: RE: Combining Form Fields ? INSERT INTO tbl_contact (contactname,...) VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.Title# #form.Forename# #form.Surname#, ... ) -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: dinsdag 30 september 2003 16:22 To: CF-Talk Subject: Combining Form Fields ? I have three form fields that will make up a name, these are Title, Forename and Surname. Is it possible to combine the contents of these three form fields so it is entered into 1 database field. So basically is it possible for the form elements below to be entered as 'Mr Ian Vaughan' in the contactname database field ? tr td width=15% class=sectionSummaryTitle/td td width=85% select size=1 name=title option selectedSelect a Title/option option value=MrMr/option option value=MrsMrs/option option value=MsMs/option option value=DrDr/option option value=RevRev/option /select/td /tr tr td width=15% class=sectionSummaryForename/td td width=85%input name=forename class=mini size=30/td /tr tr td width=15% class=sectionSummarySurname/td td width=85%input name=surname class=mini size=30/td /tr _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using cfobject
You ought to be able to get the authenticated user from the cgi vars, cgi.remote_user or cgi.auth_user, not sure about getting the computer name using thsi method though. Alex -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 29 September 2003 12:53 To: CF-Talk Subject: Using cfobject Hi, I'm using the line to grab the computer name and the authenticated user on a WIndows 2000 Server. cfobect type=COM name=w class=WScript.Network action=""> cfcookie name=DisplayComputerName value=#w.ComputerName# expires=never cfcookie name=DisplayAuthenticatedUser value=#auth# expires=never Is there a better way of getting this information without using cfobject? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX and SQL Server database connection problems
Hi all, We've just upgraded a couple of our development servers from CF5 to CFMX(6.1) and we're having problems getting CFMX to connect to MS SQL2Kdatabases on another server. When we were using CF5 (behind firewall) wecould connect fine to databases on 2 different servers (one behind thefirewall and one in the DMZ), but now we're on MX I can;t get connected tothe databases in the DMZ. Whilst on CF5 we had network control create a route through the firewall onport 1433 so we could connect to SQL, but this doesn;t seem to do the trickanymore. I'm trying to use the built in MS SQL driver, but if I create anODBC socket connection I can connect - what's going on??! to use the builtin MS SQL driver, should we get a different port opened? Any help would be very much appreciated, Thanks,Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and SQL Server database connection problems
Yes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login failure, but we're getting timeout errors AlexCheck your password settings and ake sure you use mixed mode authentication.Jochem_[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and SQL Server database connection problems
Thanks Steve, I'll give that a go, btw we are on win2K server IIS5Alex-Original Message-From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 13:55To: CF-TalkSubject: RE: CFMX and SQL Server database connection problemsWe had a similar problem when we got locked down because of Blaster.Turns out that we had to create an odbc connection on the cf server thatpointed to the sql server and we had to make sure that the dynamic port wasunchecked.After that was done, we didn't use the odbc, but it worked properly.Itjust had to be there.Hope this helps.(of course the cf server is on a windows machine, I don'tknow how you would do it on other os').Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
SQL doesn;t really cope with lists very well, there are some articles here(http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=csv ) about passingcsv strings to stored procs in SQL to then process, but as you'll see itstarts to get a little messy.I guess you're processing the results from a load of checkboxes and tryingto remove and add the ones the user has unticked/ticked. I would stick tousing CF to do the list processing - I'm sure someone will correct me if I;mway off! Just do one delete statement to remove all the existing references (for theparticular user or whatever), then loop through the list in CF and add allthe references from the new list.HTHAlex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:14To: CF-TalkSubject: OT : SQL List ComparisonAnyone know if and how you can compare two lists in SQL?real world examples could beList 1 : 1,54,36,98,32,67List 2 : 54,98,67Which obviously means 1,36,32 have been removedand indeed this could also be possible : List 1 : 1,54,36,98,32,67List 2 : 54,98,67,36,100,12Which obvioulsy means that 1 32 have been removed and 100 12 have beenaddedits a puzzler...it must be able to be be done...? _[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
If you need to track what's been inserted/deleted, then you could (beforeyou do any db inserts/deletes) loop through the old list and find whichvalues aren;t in the new list - to find whats been deleted, then loop thoughthe new list and find which values aren;t in the old list to find what'sbeen inserted. Then at least you'll have the history - still need to be CFthough!Alex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:40To: CF-TalkSubject: RE: OT : SQL List ComparisonYep, I think I will have to do things in CF, though unfortunately forlogging purposes I need to know a little more about what they haveselected/removed before the deletion / insertion occurs. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can # character to pass though string without processing?
You can use a double # so that CF will recognise that you want to display the #...so your a tag should be something like this... a href=listingdetail.cfm?newimage=#PhotoID#ListingID=#ListingID###photo Alex -Original Message- From: Britta Bennett [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 07:40 To: CF-Talk Subject: Can # character to pass though string without processing? Does anyone know how to pass a hash through a string that is being processed without setting off cold fusion, eg how to encode it so CF will ignore it? I've got to target an anchor from a query string burried in the middle of a query output. Usually I'd just make sure that part was not being processed, but in this case I'm stumped. I'd like to do a href=listingdetail.cfm?newimage=#PhotoID#ListingID=#ListingI D#'#photo' but this obviously does not work. I've tried double and single quotes. Thanks very much if anyone could point me in the right direction... Cheers, Britta Bennett WestCoastWeb.com cfoutput query=photosq a href=listingdetail.cfm?newimage=#PhotoID#ListingID=#ListingID# IMG SRC=photos/#ThumbnailPhoto# class=photo2/a Multiple more rows... /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137861 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: sql question
SELECT COUNT(id_col), id_col FROM myTable GROUP BY id_col HAVING COUNT(id_col) 1 Should do the trick for you, Alex -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: 19 August 2003 15:10 To: CF-Talk Subject: sql question i would like to write a sql query that can find where a certain 'id' has a duplicate. i don't want to see the ids where there is only one instance of it. (for example, show me 20010001 if there are 2 of them in the db, and don't show me 20010002 if there is only one of them in the db). anyone have any suggestions? thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Webservices, Components passing parameters
Hi all,
OK, can anyone tell me what I;m doing wrong here... I have created a very
simple webservice (see code below), which works fine if I try to call it as
a cfc, but as soon as I try to call the method as a webservice, I get the
error 'Web service operation getDocTitle with parameters {5459} could not
be found.'
If I comment out the parameter/argument bits - so nothing is passed and
nothing is expected by the cfc - it all works fine. I'm sure there must be
something simple I've missed
TIA
Alex
Code samples:
cfc page:
cfcomponent
cffunction name=getDocTitle access=remote returntype=string
cfargument name=DocumentID type=numeric required=yes
cfquery name=qry_getDoc datasource=#request.dsn#
SELECT DocumentTitle FROM tblDocument
WHERE DocumentID = cfqueryparam
cfsqltype=cf_sql_integer value=#arguments.documentid#
/cfquery
cfreturn qry_getDoc.DocumentTitle
/cffunction
/cfcomponent
Calling page:
cfscript
DocumentID = 5459;
ws =
createobject(webservice,http://kn-dev.open.ac.uk/testarea/webservice/docu
ment.cfc?wsdl);
testvar = ws.getDocTitle(#DocumentID#);
/cfscript
cfdump var=#testvar#
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: serving a file for download with cfcontent.
You just need to put in a cfheader tag just before the cfcontent tag... cfheader name=Content-disposition value=inline; filename=myfilename.xls HTH, Alex -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 05 August 2003 15:58 To: CF-Talk Subject: serving a file for download with cfcontent. Hi all, I have a problem with a really short time frame to serve up a file. I created a page with just a cfcontent that looks like this: CFCONTENT FILE=#FileSystemRoot##RootDir#myfile.exe type=application/octet-stream The problem is that when a person clicks on the link they get a box to save a file with the name of myfile.cfm (the name of the cf page with the cfcontent). Can someone tell me what I am doing wrong? The link that goes to that page is: a href=myfile.cfmDownload my EXE file/A *COST SAVINGS SUGGESTION* For pages that must be printed, change your print settings to print in grayscale instead of color. Steve Durette Mgr-Eng. Const. Systems Support 100 S. Main Room 314 Mt. Clemens, MI 48043 Ofc: 586.466.7654 Fax: 586.466.1109 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Somewhat OT: ER diagramming tools?
I usually use MS Visio - the basic version contains all you'd need to do ER diagrams and it's not very expensive - though not as cheap as shareware. If you're using SQL2K (not sure about v7) you can get it to auto generate the ERD from the existing tables/relationships, but that doesn't help if you're at the design stage ;-) Alex -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 15:47 To: CF-Talk Subject: Somewhat OT: ER diagramming tools? What do youse guys use to do ER diagrams? I'm in need of some diagramming tools, as we're working with more and more people in our process now and feel the need to put down our diagrams and relationships in more concrete form. I'm looking for shareware or freeware diagramming tools that can do very basic things. I'm not looking for anything fancy...yet. I just need to be able to visually display tables and relationships and maybe just output it as a bmp or jpeg file for group consumption. Does anything jump out at anyone? I appreciate the help. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Moving from MySQL to MS SQL Server 2000
You mentioned earlier that 'I've added the database via Data Sources (ODBC) under the System DSN tab using the SQL Server driver. I did a test and it passed.' Have you checked that the data source is working/valid using CF admin? You could also try to see if it's only that table where the error is occuring or if its other queries run through cf too. - I assume that as it's a check login function it runs before pretty much any other code? Alex -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 14:48 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 Execute sp_tables and see what tables get returned, make sure tbllogin is listed. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:45 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 HmmmI just changed all the table names to have tbl at the beginning. I ran a test using the SQL Query Analyzer. Just did a simple select * from tbllogin Worked fine until I tried to run the simple query within my .CFM template cfquery name=checkpass datasource=databasename select * from tbllogin /cfquery and I get the same error as before? I don't know whats going on. ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbllogin'. On Wed, 13 Aug 2003 09:39:00 -0400, Bryan F. Hogan wrote: Don't know I've never worked with MySQL. It's just good design. I had the same problem when I first started, I would rack my brain, bang my head against the wall, scream, holler, etc. Then someone finally told me it was a reserved word and I kicked my ex boss in the head. :) -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:37 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 OK...It seems MySQL is more forgiving. Thanks On Wed, 13 Aug 2003 14:28:13 +0100, Craig Dudley wrote: A fair amount of people simply start table names with 'tbl', which would solve your problems. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 14:28 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 Login is a reserved word. Change the login table name to something else and it will work. Try not to use names for anything that are simple names, such as login, password, name, position, etc. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:27 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 It's a simple query. cfquery name=checkpass datasource=databasename select * from login /cfquery I've added the database via Data Sources (ODBC) under the System DSN tab using the SQL Server driver. I did a test and it passed. On Wed, 13 Aug 2003 09:03:55 -0400, Mark Stewart wrote: The only thing I had to do was change the double quotes to single quotes. As for the error, could you post the query so we can see what's going on? Mark -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 7:21 AM To: CF-Talk Subject: re: Moving from MySQL to MS SQL Server 2000 Hi, I've just migrated my databases over to SQL server. DO I need to change any of my CF code especially my cfquery tags? I get this error when running my app. ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'login'. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity and ASP pages
Your best bet might be to move to using the Verity K2 spider search, so that the pages are actually processed, this would then ensure no asp or cfml code (or php etc) gets returned in the search results. Alex -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 08:39 To: CF-Talk Subject: Verity and ASP pages Urgent help needed please. We've had to change all our web page extensions to asp (from htm - cfm pages remain untouched). Verity indexes the pages but returns ASP code in the results, particularly anything starting %. I thought of cutting this out but even when the full string is returned invariably there is no ending % and if I cut the whole thing out there would be no search results to display anyway (which I suppose is the lesser of 2 evils but is still undesirable). How can I stop this. TIA!! ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Webservices, Components passing parameters
Thanks André,
all working now, I knew it must have been something simple - but not quite
_that_ simple ;-)
Alex
-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 08 August 2003 10:13
To: CF-Talk
Subject: RE: Webservices, Components passing parameters
Try this:
Go to your ColdFusion Administrator. Locate the web service
in question
via Data Services - Web Services. Click on the refresh icon.
Try running your code again.
André
-Original Message-
From: A.Little [mailto:[EMAIL PROTECTED]
Sent: 08 August 2003 10:00
To: CF-Talk
Subject: Webservices, Components passing parameters
Hi all,
OK, can anyone tell me what I;m doing wrong here... I have created a
very
simple webservice (see code below), which works fine if I try
to call it
as
a cfc, but as soon as I try to call the method as a webservice, I get
the
error 'Web service operation getDocTitle with parameters
{5459} could
not
be found.'
If I comment out the parameter/argument bits - so nothing is
passed and
nothing is expected by the cfc - it all works fine. I'm sure
there must
be
something simple I've missed
TIA
Alex
Code samples:
cfc page:
cfcomponent
cffunction name=getDocTitle access=remote returntype=string
cfargument name=DocumentID type=numeric
required=yes
cfquery name=qry_getDoc datasource=#request.dsn#
SELECT DocumentTitle FROM tblDocument
WHERE DocumentID = cfqueryparam
cfsqltype=cf_sql_integer value=#arguments.documentid#
/cfquery
cfreturn qry_getDoc.DocumentTitle
/cffunction
/cfcomponent
Calling page:
cfscript
DocumentID = 5459;
ws =
createobject(webservice,http://kn-dev.open.ac.uk/testarea/w
ebservice/
docu
ment.cfc?wsdl);
testvar = ws.getDocTitle(#DocumentID#);
/cfscript
cfdump var=#testvar#
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfschedules....
I;ve also experienced this (on CFMX), where monthly scheduled tasks end up running at 'odd' times. I didn;t find out the cause of the problem, but what I did in the end was to amend to the script template so that it checked for the current day/date first...eg... cfif dateformat(now(),'d') eq 1 !--- code to run task --- cfelse !--- do nothing --- /cfif and I then amended the scheduled task so that it ran daily HTH Alex -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: cfschedules Hi there, We have a problem with cfschedule that is proving very annoying now. We created a task to be run on the 1st of every month called newsmail. We noticed that the task was being run at odd times so decided to do further investigation - the task was deleted and then yesterday morning we noticed that the newsmail had been run again. We checked the logs and found the following: Information,jrpp-599,07/30/03,11:25:37,,[NewsMail] Activating2 on Wed Jul 30 11:25:37 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 Information,jrpp-599,07/30/03,11:26:57,,[NewsMail] Activating2 on Wed Jul 30 11:26:57 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 This task was deleted and is now activating itself and setting it to run on 'Tue Aug 26 07:00:00 BST 2003'. Anyone had any similar fun with cfschedules or any sensible suggestions for getting round it? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
I think it depends on the datatypes you're using as inputs to the division calculation, if they are integers then it does have problems, you could try using: (CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2 are integers Alex -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:15 To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-0801 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ** ** * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
I find the main reason for using identity PKs is that the urls generated are much shorter and easier for the user, especially if they have to type them in from a printed url... eg: http://www.mydomain.com/index.cfm?id=12345 or http://www.mydomain.com/index.cfm?id=E5460D40-2163-4C10-95EC-A4ADB319A126 Alex -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 15:56 To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how to free up some log space in SQL server 2000?
Do a backup of the transaction log, and under the 'options' tab in SQL Ent. Manager select the 'remove inactive entries from transaction log' option. You'll probably want to have the transaction log backed up regularly (at least daily) - so when you do the transaction log backup, also select the option to schedule the job. These might be of some help... http://www.sqlteam.com/FilterTopics.asp?TopicID=115 http://www.sqlteam.com/FilterTopics.asp?TopicID=116 HTH, Alex -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:51 To: CF-Talk Subject: how to free up some log space in SQL server 2000? hi all My log file is full. And I need to free some space in log file. Could you please show me how to do it? Thanks John __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anti Leech Ideas?
You could make the download area password protected and issue a unique password to the user, who has to enter it to access the download. Then just ensure that each password can only be used once. One problem you may encounter is users entering the download area, but not downloading the software, then getting stuck when they try to enter the area again , as the password will have expired. HTH, Alex -Original Message- From: Oliver Cookson [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 13:54 To: CF-Talk Subject: Anti Leech Ideas? Hi, I have built e-commerce site selling a piece of software. Once authorisation has been approved from the merchant banker I forward the user to a protected part of the site (session vars) where they click on the link to download the software. The problem is this link could be freely distributed for anyone to commence download. I know I could dynamically change the location of the directory but I would prefer not to do this. Is there a way of hiding the location of the download? Im stumped how to go about doing this. Any thoughts would be great. Cheers ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchart hanging
Hi all, We've recently upgraded to CFMX and I'm in the process of changing our references to cfgraph to cfchart, but I'm finding that cfchart doesn't always generate a graph, the browser just sits there with the progress bar stuck. The rest of the pages display fine (including text/data after the cfchart tag). The cfchart tags are just on our web admin pages, so only a couple of people use them - but I'd like to get it cleared up. any ideas? Alex ps. the graphs should be generating much less than the chartseries limit of 16 which I've seen in the cfmx known bugs. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Includes inside a CFOUTPUT problem...
I don;t think the cfoutput is inherited by the cfinclude templates from the calling template, so you'll need to put cfoutput in each of the include templates where you want to output a variable. Don't ask me why it works like this - I have no idea ;-) Alex -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 16:38 To: CF-Talk Subject: RE: Includes inside a CFOUTPUT problem... :: What about :: td#prods.some_variable#/td :: in the includes ? :: That's better syntax anyway... Nope, still doesn't do it H. Re: cfoutput query=prods tr cfswitch expression=#URL.ID# cfcase value=100 cfinclude template=includes/td_1.cfm cfinclude template=includes/td_14.cfm cfinclude template=includes/td_22.cfm /cfcase cfcase value=110 cfinclude template=includes/td_33.cfm cfinclude template=includes/td_34.cfm cfinclude template=includes/td_35.cfm /cfcase /cfswitch /tr /cfoutput ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL and Dates
(syntax for MSSQL2K)... WHERE Date = getdate() AND Date = dateadd(d,6,getdate()) should work. That way you don;t need to bother creating and passing the dates using CF. You might also want to change the name of your column 'date' as it's a reserved word. Alex -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 13:17 To: CF-Talk Subject: SOT: SQL and Dates What is the proper SQL statement for something like... WHERE Date BETWEEN #createodbcdate(Now())# AND (#createodbcdate(Now())# + 6) I know that's not right (because it doesn't work). Any ideas? Just trying to pull today's date and the rest of this week's dates. Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Need to disable print button or at least trap and display a message.
You can also use style sheets to determine what gets printed as opposed to what users view on screen - so just use a media=print stylesheet and make it blank - or something! eg: link href=/css/knstyle.css rel=stylesheet type=text/css media=screen link href=/css/knprintstyle.css rel=stylesheet type=text/css media=print We use this method so that people don;t end up printing all the menu/banners etc from webpages. But I've found this only works reliably with IE (4+?) through. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 16:47 To: CF-Talk Subject: Re: OT: Need to disable print button or at least trap and display a message. You could use the onbeforeprint event to hide the page before it prints. But, it could be that perhaps the form should be reworked so that it's easier for users? How about if faxed requests are simply rejected? - Original Message - From: Ciliotta, Mario [EMAIL PROTECTED] Date: Wednesday, July 9, 2003 9:08 am Subject: OT: Need to disable print button or at least trap and display a message. Hi all, I was wondering if someone will be able to help me with a issue that I am having. I need to be able to either disable the print button in the browser toolbar (IE only) or trap that the user click the print button and display a message, that the form is not complete or if it is possible to print a different document, then the unfinished form. I know that I can open the form in a browser window without the toolbar but people get real ticked off if that tool bar is missing and then call the support desk to complain that their browsers is not working correctly. The problem basically is that my users are lazy and will print off a half completed form, then fill in the rest of the fields by hand and then fax the form - instead of doing it all online. The form needs to be printed at the end but that is after all the fields are filled out. If anyone knows how to stop this, that would be great. We are using CFMX for this application if that matters - maybe CF could be used to trap the print??? Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Timeout for cfhttp
Hi all, I'm using cfhttp in CFMX, and according to the docs the 'timeout' attribute doesn't function with JDK 1.3 (which is what I'm using) so occassionally the page just hangs indefinitely. Is there some code I could put around the cfhttp tag which will replace the function of the timeout attribute? I was looking at using something like cftry timeout=123, but cftry doesn't have a timeout ... or any other ideas? thanks, Alex ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parse formated list
You could use listfind() instead in your cfif query - this then won't find the incorrect matches that you're getting at the moment. Alex -Original Message- From: jeremy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:16 To: CF-Talk Subject: Parse formated list I have a list of days in a month being returned from a query. Example record set would be 2,19,19,21,27 Number between 1 and 31. I then loop through this query with the code below which generates a list var that looks like 19,19,21,27 when outputted. CFLOCK Scope=Session Type=Exclusive Timeout=5 CFSET Session.Calendar.EventListingDate = CFLOOP Query=getmonth CFSET Days = #DateFormat(getmonth.auctiondate, dd)# CFSET Session.Calendar.EventListingDate = ListAppend( Session.Calendar.EventListingDate, Variables.Days) /CFLOOP /CFLOCK That is all well. HERE IS THE PROBLEM. The problem is here with this cfif. Session.Calendar.EventListingDate contains the above list 2,19,19,21,27 And Variables.CurrentDay is a single number between 1 and 30. If CurrentDy is say 7 then this if evaluates true as 7 is in 27, but I don't want that. I want the cfif to check for JUST 7 in the comma delimited list. How would I do this. It seems like there should be a list fucntion for this but I can't find it. cfif Session.Calendar.EventListingDate contains Variables.CurrentDay /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Message: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0...
I've come across the same problem - only occassionally though and I can't reliably reproduce it. I did find though that it only occured when the page was displayed as a result of submitting a cfform, I couldn't get to reproduce the error at all if the page was called from a normal html form HTH Alex -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 21:41 To: CF-Talk Subject: Message: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0... For some reason the full message did not display, so I am reposting it below: === HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Wed, 02 Apr 2003 17:01:32 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Page-Completion-Status: Normal If I do a refresh the message goes away. Any ideas what is going on and how to prevent the message from appearing in the first place? Stan Winchester AfterShock Web Design, LLC [EMAIL PROTECTED] http://www.aftershockweb.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: distinct count
You could try removing the a_items.END_TIME from your select and group by clauses to see if that does what you need, as if each of the values for a_items.END_TIME are different the query will create a row in the resultset for each value. Does that help? Alex -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 04:35 To: CF-Talk Subject: RE: distinct count Nope. That wasn't it. I removed the time stuff and it didn't change the results. Yet I can't see any real other difference between the queries. H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:09 PM To: CF-Talk Subject:RE: distinct count OK, I just realized something about this query ... I have a similar query for another part of the site that is exactly the same query, except their is no date comparison. That's why I'm not getting the results I expect (the other query works the way I expect), because since each entry has a diffferent SMALLDATETIME value, it counts as one ... now I've got to figure out a work around ... any suggestions? H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:01 PM To: CF-Talk Subject: SQL: distinct count The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: working with objects
I came across a similar problem and ended up having to change my code so that it looks like; cfscript objDoc = objWord.Documents; newDoc = objDoc.open(c:\mydocument.doc); myRevisions = newDoc.Revisions; MyRevCount = myRevisions.count; MyComments = newDoc.Comments; MyCommentCount = MyComments.Count; /cfscript So instead of using the object 'dot' notation as it should really be used, you can only have one dot per expression. Hence why I've got: myRevisions = newDoc.Revisions; MyRevCount = myRevisions.count; Instead of: MyRevCount = newDoc.Revisions.count Perhaps the reason your code isn't working is because the document isn;t being opened properly or at all (too many dots in your OpenDoc statement) HTH, Alex PS. Don't ask me why it works the way it does! -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 14:51 To: CF-Talk Subject: working with objects OK, working with the MS Word object (still). I need some help porting over this VB code to CF so that it will work. Here is the VB Code: Sub Test() Dim DocOpen As Word.Document Set DocOpen = Documents.Open(c:\blah.doc) Set temp = Dialogs(wdDialogToolsWordCount) temp.Execute numWords = temp.Words With DocOpen MsgBox This doc has a count of numWords .Close wdDoNotSaveChanges End With Set DocOpen = Nothing End Sub Works perfectly. So I am trying to get this to do the same thing in CF, without the msgbox, obviously. Here is where I have gotten: CFSCRIPT OpenDoc = objWord.Documents.Open(c:\blah.doc); Count = opendoc.words.count(); temp = openDoc.Dialogs(wdDialogToolsWordCount) OpenDoc.Close(); objWord.Quit(); objWord = Nothing; /CFSCRIPT Does not work, it is telling me that wdDialogToolsWordCount is undefined. So I have even tried declaring a variable like myvar = wdDialogToolsWordCount and it still fails. How can I port this VB over to CFScript where it works? Can anyone help? Thanks in advance! Thanks! Robert Bailey Famous for nothing ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity with Includes Problem
The CF5 Verity can spider (but only licensed to spider 'localhost'), but only if you set up the K2 Verity server. Otherwise it (as you say) just indexes the file system with no parsing. Alex -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 07 March 2003 10:19 To: CF-Talk Subject: RE: Verity with Includes Problem As I understand it: pre-MX Verity is not a spider, and only indexes FILES in the local file system. No CF parsing. It would probably be better to have all major content in a database and use something like MSSQL's full-text indeces -- I have good experience with that. Hugo ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: need a bb script
try http://fbopenforums.sourceforge.net/ Alex -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 14:19 To: CF-Talk Subject: Re: need a bb script On Wednesday 05 Feb 2003 15:25 pm, Dimo Michailov wrote: http://fbopenforums.sourgeforge.net - free, easy to customize, and very easy to extend and modify. FB3 compatible. That URL is dead ? -- Tom C Computers Are Better Than Humans Because #1: Humans are forgetful and have limited memory. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion and Verity Results ???
Why not have the link built into the collection? So why you do the indexing from the db instead of the title being 'xxx' the title is 'a href=mylinkto.htmxxx/a'? Then when you're outputting the results when the user has selected all collections you don;t need to worry about which individual collection the result came from. Alex -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 09:09 To: CF-Talk Subject: Re: Coldfusion and Verity Results ??? Ryan When I set up my collections I am already using the custom1 and 2 fields in my collections. I have the search working when just searching individual collections as you can see from my code in the previous mail, I just need the search to return all search results when the user selects search all collections So could I use another approach ?? for example use cfif isDefined(collectionname) For example cfelse !---Start output for all results--- pnbsp; CFOUTPUT query=GetResults maxRows=#Form.MaxRows# cfif isDefined downloads cfoutput query=GetResults maxRows=#Form.MaxRows# Ba href=http://intranet.neath-porttalbot.gov.uk/itintranet/itdow nloads/downloa ds/#custom1##title#/a/B p#summary#br Search Relevance :#NumberFormat ( Round ( Score * 100) )# %/p /CFOUTPUT /cfif cfif isDefined itlinks cfoutput query=GetResults maxRows=#Form.MaxRows# Ba href=linkurl##linktitle#/a/B p#summary#br Search Relevance :#NumberFormat ( Round ( Score * 100) )# %/p /CFOUTPUT /cfif etc. - Original Message - From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 4:56 PM Subject: RE: Coldfusion and Verity Results ??? Ian, I am doing the same thing you are trying to get at. My results can be any number of collections including text-based and db-based, just supply cfif statements if the custom parameters are supplied for this particular record. If you have set up the return url correctly in the collections, you will be able to use the #url# parameter instead of static links such as /itdownloads/downloads/ tr tdnbsp;/td td colspan=2url: a href=#url#cfif isDefined(custom1)#custom1#/cfif#url# cfif isDefined(custom1)#custom1#/cfif/a /td /tr -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 5:59 AM To: CF-Talk Subject: Coldfusion and Verity Results ??? Hi I would be grateful if somebody with an in depth experience of coldfusion and verity can help moe achive my goal here please From the search form below the user has the option of searching all of the site or just individual collections such as Links, Software Downloads... FORM action=search11.cfm method=post name=searchform input type=hidden name=StartRow value=1 input type=hidden name=MaxRows value=25 Search for : input name=Criteria size=25 value= select name=search size=1 option value=AllAll of the site/option option value=itlinksLinks/option option value=downloadsSoftware Downloads/option option value=itdocsDocument Knowledgebase/option option value=itarticlesNews/Area/option /select /form In the search results page how can the results of the search be shown, as the user may have chosen to search all the site (collections) if this is the case then I have the following problem... Because each link from each collection would be different for example (show below), how could this functionality be achieved in the results?? a href=/itdownloads/downloads/#custom1##title#/a a href=/itnews/articledetail.cfm?id=#key##title#/a a href=#custom1##title#/a ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion and Verity Results ???
When you index each collection set custom2 to be some value, eg 'link','download' etc. Then when you come to output the results just do a cfswitch/case to determine which link the key or title should go to and display accordingly. Alex -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 11:59 To: CF-Talk Subject: Coldfusion and Verity Results ??? Hi I would be grateful if somebody with an in depth experience of coldfusion and verity can help moe achive my goal here please From the search form below the user has the option of searching all of the site or just individual collections such as Links, Software Downloads... FORM action=search11.cfm method=post name=searchform input type=hidden name=StartRow value=1 input type=hidden name=MaxRows value=25 Search for : input name=Criteria size=25 value= select name=search size=1 option value=AllAll of the site/option option value=itlinksLinks/option option value=downloadsSoftware Downloads/option option value=itdocsDocument Knowledgebase/option option value=itarticlesNews/Area/option /select /form In the search results page how can the results of the search be shown, as the user may have chosen to search all the site (collections) if this is the case then I have the following problem... Because each link from each collection would be different for example (show below), how could this functionality be achieved in the results?? a href=/itdownloads/downloads/#custom1##title#/a a href=/itnews/articledetail.cfm?id=#key##title#/a a href=#custom1##title#/a ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: include_once (PHP)
Yes, not quite as easy as in php though. The logic I've used before goes something like: cfparam name=request.included default=false type=boolean cfif not request.included cfinclude template=mytemplate.cfm cfset request.included = true /cfif HTH Alex -Original Message- From: Harry Klein [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 10:00 To: CF-Talk Subject: include_once (PHP) Would it be possible to implement this PHP functions in ColdFusion? include_once() and require_once(). they will include() or require() the requested file only if the requested file has not yet been included previously during the processing of the current request. That way, your code will only require a function library _once() during a request. Harry Klein ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DWMX - Moving blocks of code.
It's still there in DWMX... but you need to use Ctrl+alt+] and Ctrl+alt+[ Alex -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 13:30 To: CF-Talk Subject: DWMX - Moving blocks of code. I enjoyed the feature in CF Studio that allowed you to highlight blocks of code and adjust the indentation using left/right arrow buttons. Have I overlooked this feature in DWMX or has it been omitted? I found it to be very handy for code readability. Thanks, Dave Bosky HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Better display method?
Depends a bit on what database your using, if your using MSSQL have a look at http://www.sqlteam.com/item.asp?ItemID=2955 as it looks from your query as you're trying to create a crosstab/pivot table (where rows in the query become columns). If you're using MS Access, it's a bit easier as you can use the TRANSFORM statement. HTH Alex -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: 06 December 2002 15:27 To: CF-Talk Subject: RE: Better display method? A complete unknown ... - Projects are unlimited - Groups are unlimited - Users are unlimited - Status will be In Progress, Complete, or N/A -- Jeff -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 9:18 AM To: CF-Talk Subject: Re: Better display method? Jeff D. Chastain wrote: Anybody got a quick, clean, solution? Am I missing something here? What is the maximum number of different projects, groups, usernames and status'es (statuses?) you are going to have at any one time? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CFMX and ISAPI Filters
Hi all, I'm trying to upgrade our dev server from cf5 to cfmx and am having a little problem... (btw its win2k iis5 sql2k). The security on our websites depends on an isapi filter which redirects the user to a secure login page, sets a cookie then allows the user back to the website. The cookie is only persistent during the open browser session. After having installed cfmx there appears to be some kind of conflict between our security isapi filter and the CFMX Jrun Connection Filter - in that sometimes our security isapi filter runs first and the user can login, or the Jrun isapi filter runs first and ignores the security. The means that sometimes you can login and sometimes not. It seems to be in a similar vein to a message posted in the macromedia forums (though no solution has been offered yet): http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=12threadid =500822highlight_key=ykeyword1=isapi Unfortunately, we are required to use the university's security isapi filter, so we can't remove that, so am I stuck with going back to cf5? or are there any other options open to me? One thought I had was that we move to apache as the problem above is partly due to iis. Any thoughts, suggestions (or even a solution!) would be much appreciated. TIA Alex Little Web Developer Institute of Educational Technology Open University, UK ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Error 232
I'm not sure that you can tell CF to stop logging 232 errors. But using CF administrator you can store the log file without having to restart cf. Just go to the CF admin log files page, the 'store log file' option is the yellow button under controls. This will then store your server.log file as server.001 in the log file directory on your server. Then when CF needs to write to the server log it will create a new server.log file. You'll then be free to do what you like with the server.001 file without affecting the CF service. This doesn's solve the root cause of the problem though. You could look at query/page caching to speed up the response time of the page. HTH Alex -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 05:07 To: CF-Talk Subject: Error 232 Hi I am running CF5 with a variety of MS Access and Oracle 8 databases. A recurring problem I experience is that on pages with long lists of query data, if the user clicks away to another page before the page finishes loading, my server.log file fills up with Error 232 messages. I believe that 232 is an error that occurs when the database is unable to communicate with the page requesting the data - in this case, because the user has moved on to a new page, the data has nowhere to go. The end result of the above, is that the server.log file grows alarmingly if not closely monitored - once it grew to 1.5Gb (that's not a typo) and took up all the space on the server c:\ and crashed the server :-( The log file cannot be deleted because CF is continually writing to it, and the file is in use. The only way to stop it is to restart the CF Application Service - thus also clearing all application and session variables, and stuffing up all the applications on the server. Can I tell CF to stopp logging 232 errors? Or can I stop the error? I know one way is to limit query output to 50 rows per page, but in my current application that would result in a poor user interface. Any ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: True is False
You've got an extra 's' in LoadNewSession on the 3rd line of code. Alex -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: 14 November 2002 14:19 To: CF-Talk Subject: True is False I must be missing something really obvious. This is the code ( In the application.cfm ): cfset variables.LoadNewSession = false cfoutputLoad New Session: #variables.LoadNewSession#/cfoutputbr cfset variables.LoadNewSesssion = true cfoutputLoad New Session: #variables.LoadNewSession#/cfoutputbr This is the output: Load New Session: false Load New Session: false Did I just discover some weird bizarre bug? Or am I just really confused? Can anyone else replicate this? I have tried everything I can think of. For the record if I remove the first two lines, I get an error on 4th saying that the variable LoadNewSession is undefined. It seems to be ignoring that third line? Am I conflicting with a Java reserved word? -- Jeffry Houser | mailto:jeff;farcryfly.com DotComIt, Putting you on the web AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
SOT: Temporary tables in SQL2K
Hi all, I'm writing a stored procedure (in SQL Server 2K) in which I need to create a couple of temporary tables (which are dropped when the sp has completed). How do I get around the fact that 2 users of the website may run the sp at (precisely) the same time, creating the possibility that one of the sp's drops the temp table before the other has finished with it. The SQL documentation refers to the fact that each 'connection' will create it's own copy of the temp table - avoiding the problem above, but when the db is connected to the website, I only have the one connection between CF and SQL, so the problem may occur - or will it? Does anyone have any advice/best practice for this situation? thanks, Alex ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Temporary tables in SQL2K
Nevermind, I've found I can use the TABLE variable type in my sp so the table is only created locally to the sp (btw, this is new to SQL2K). Any advice/experience on the performance of this would still be appreciated, Alex I'm writing a stored procedure (in SQL Server 2K) in which I need to create a couple of temporary tables (which are dropped when the sp has completed). How do I get around the fact that 2 users of the website may run the sp at (precisely) the same time, creating the possibility that one of the sp's drops the temp table before the other has finished with it. The SQL documentation refers to the fact that each 'connection' will create it's own copy of the temp table - avoiding the problem above, but when the db is connected to the website, I only have the one connection between CF and SQL, so the problem may occur - or will it? Does anyone have any advice/best practice for this situation? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFMX possible bug, anyone care to verify
The code you're using to generate a long string will give: For 1-9 it will produce: 123456789 (making len(str)=9) but for 1-10 it will give 12345678910 (making len(str)=11) etc So the string len that you're getting (53799) sounds about right when the loop goes up to 12981. Doesn;t explain why the regex fails though ! Alex -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: 30 October 2002 16:06 To: CF-Talk Subject: RE: CFMX possible bug, anyone care to verify Hi Brook, I tried your code and for 12981 got Ths string is 53799 chars long (No null pointer exception) for a hoot I bumped it up to 5 I got Ths string is 238894 chars long (No null pointer exception) It is a phat box though. W2k, jdk1.4.0_02, IIS5 -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Tuesday, October 29, 2002 4:26 PM To: CF-Talk Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Server Performance
On CF5 (and cf4.4 I think- can't remember exactly) in the CF admin pages and go to 'logging settings' (under the tools option in the top left). On that page you can set the server to record pages which take longer that x seconds. hth, Alex -Original Message- From: Shahzad.Butt [mailto:Shahzad.Butt;JJFastFood.com] Sent: 28 October 2002 13:27 To: CF-Talk Subject: Server Performance Hi Some application/request is killing my server (running intranet). And almost everyweek my server stops working (for intranet) and when I check the server there is message OUT OF VIRTUAL MEMORY. I want to log all applications which are taking longer than 2 minutes (to find the culprite one). How can I log all requests for my intranet which are taking more than X time and also that would be great if I define time span as well. That logs TIME and NAME/URL for page which are taking more than 2 minutes from 28th Oct o 30th Oct and on 30th I'll check log file and sort it by time. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT: SQL Server database problem
You don;t need to trim these down to 16 chars as that isn't the max length you can store in a SQL 'text' field - it's something like up to 2Gb of data (on SQL2K) - even though the length says 16 on the table design (I think this was discussed in a thread here 2 or 3 weeks ago) and changing this length will make no difference. The SQL text field is like a memo field in Access. So with the data you are inputting to MessageTitle, MessageTeaser and MessageBody you should have no problem. You've not given the field length for the 'Status' column into which you;re trying to insert 16 chars - could this be the problem ? Alex -Original Message- From: John Morgan [mailto:gameczar;zbzoom.net] Sent: 28 October 2002 15:14 To: CF-Talk Subject: Re: OT: SQL Server database problem You should either trim the text being inserted using the left function ... EXAMPLE: Left(form.MessageTeaser, 16 ) or you should expand the size of the field in the table. If this is data input via a form you could use the size option in the input tag to enforce the size restriction but I would still trim the data with the left function for safety sake. EXAMPLE: input type=Text name=MessageTeaser size=16 -John- At 02:58 PM 10/28/2002 +, you wrote: * * WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message * * Hi, I have a SQL Server 7 database and I am trying to insert a large amount of text, passed by a ColdFusion form, into a table within this database. The problem I am having is a ODBC Error Code = 22001 (String data right truncation) error. My table design is like this. Column name DatatypeLength MessageID int 4 MessageType char20 Department char20 CreationDatechar15 PublicationDate char15 MessageTitletext16 MessageTeaser text16 MessageBody text16 I think that the problem is when the text is being added to the fields, MessageTitle, MessageTeaser and MessageBody. This is the complete error message: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = INSERT INTO Messages ( MessageType, Department, CreationDate, PublicationDate, MessageTitle, MessageTeaser, MessageBody, Status ) VALUES ( 'None', 'Housing', '28/10/2002', 'Awaiting', 'Some text to throw error', 'Some text to throw error, Some text to throw error', 'Some text to throw error,Some text to throw error and Some text to throw error', 'Awating Approval' ) Data Source = WIRE_USERS The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (24:1) to (24:57) in the template file E:\INETPUB\WWWROOT\WIRE\MESSAGES\SENDFORAPPROVAL.CFM. Anyone know how I can fix this error? Thanks Stephen * * Westminster City Council switchboard: +44 20 7641 6000 * * This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. * * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Search functionality: Verity, LIKE operator, or what?
Hi, We've had exactly the same problem with our document management system - the way we originally got around it was to use 2 verity collections, DocumentMetaData (a collection of the database entries) and DocumentFile (a collection of the actual document files). Then when you do the verity search you specify both collections. You'll then need to use a query on query of the verity search result to strip out duplicates (where a record is returned from DocumentMetaData and DocumentFile, but they are actually for the same document) and you can use (another) query on query to strip out the documents that the user doesn't have access to. This method worked fine, though we found it was a bit too slow for our liking. Having verity search more than 1 collection at once seemed to slow it down quite a lot, plus the fact that you've then got the extra QoQ manipulation. We then changed how all our searching worked by making use of the full text indexing within SQL and storing a copy of the file (using cfx_PutImage) within the document table. Then we wrote a stored procedure to do the actual searching and filtering out of documents that the user doesn't have access to. We've found this to be much quicker and it gives us more flexibility to alter the ranking - for example, if the search term is found in the title of the document we multiply the ranking up (it's at x1.3 at the moment, but we're still experimenting) Hope that helps - I'm sure there's plenty of other solutions to this Alex -Original Message- From: David Notik [mailto:dave;digital202.com] Sent: 24 October 2002 00:03 To: CF-Talk Subject: Search functionality: Verity, LIKE operator, or what? Hi all: I haven't posted to this list for awhile. I used to post all the time, and used to write the TipWorld ColdFusion tips many of you received. Good to be back in the mix. My question: I built a document management system of sorts. I have all the files in a directory. there's a database record for every file with fields such as: title, filename, description, keywords, and more. The filename field references the actual physical file and it's all very simple. So now I want to provide the ability to search the files. with a twist. I have a box where the user can type in keywords. I could then write a query which uses the LIKE operator many times and searches the various relevant fields for that keyword. But is that really the most efficient way? I know I could create a collection. But doesn't a collection only search the actual content of the physical files indexed in the collection? Meaning my title, description, and keywords fields (etc.) wouldn't be relevant. What do I do? That's question one. but then let's take it a step further: I have a securitytype associated with each file record, which denotes whether the logged in user has access to the file. When a user searches for files, I DO NOT want to display files he does not have access to. I can easily accomplish this using my own query (LIKE operator and a WHERE clause that only pulls records they have access to), but if I do it the verity way, is this possible? Just trying to decide the best way to go about this. I am using ColdFusion Pro MX, SQLServer 2000. --D ### David Notik Digital202, LLC Imagination gone digital. Web: http://www.digital202.com/ www.digital202.com E-mail: mailto:dave;digital202.com [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL question
SELECT Month(my_date_fieldname) AS myMonth FROM myTable -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 14:49 To: CF-Talk Subject: SQL question Is there a way to use a Select query to get just the month out of a date in a SQL query? I have a database that has a date field in it (so 04-10-02) and I want to select all the records from a specific month. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT? Easy data entry util for SQL?
If you are going to use an access data project to connect to the SQL tables, the SQL table must have a primary key - or access won't let you edit data in the table (the PK can be composite) Alex -Original Message- From: Jeff [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 02:44 To: CF-Talk Subject: RE: OT? Easy data entry util for SQL? In addition to what Dave mentioned, you can create an Access Data Project (.adp) file that gives you access to views and stored procedures as well. HTH, Jeff -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 5:52 PM To: CF-Talk Subject: OT? Easy data entry util for SQL? We have been using Access for so long now I got used to being able to enter/edit data with a few mouse clicks, just opened up the table and started typing or making corrections (to users, parameters files, or erroneous transactions during development). Now that development has been ported to SQL, I dread the command-line data entry of ISQL 6.5. Is there an easier way to do what I got used to doing with Access? A recent article, I believe it was in CFDJ, talked about interfacing the Access front-end to an SQL database thru ODBC. Have you actually tried it? Any tips/tricks? Thanks In Advance Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: SQL error - Arithmetic overflow...?
Don't know for sure, but could it be that the fields where you're adding
27.5 are set up as integer fields? This might not have been a problem in
Access where there's just a 'number' datatype, but could make a difference
in sql with 'int', 'float', 'decimal' etc
If you've auto-upsized your access db to SQL and all the values in an access
'number' field were integers, the upsizer would probably create a SQL field
with type 'int'.
HTH
Alex
-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 03:30
To: CF-Talk
Subject: SQL error - Arithmetic overflow...?
This ran just fine using Microsoft Access. Now I get an overflow?
Can you spot what's wrong? The values in the fields aren't
very big - the
largest is like 1952 to which I'm adding 20 or 30 or so...
=
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic
overflow error
converting numeric to data type numeric.
SQL = Update MEMBERS Set status='Gold', current_point_ratio=1.25,
total_purchases=total_purchases+22,
purchases_this_year=purchases_this_year+22,
purchases_quarter_1=purchases_quarter_1+22,
total_points_earned=total_points_earned+27.5,
points_earned_this_year=points_earned_this_year+27.5,
points_earned_quarter_1=points_earned_quarter_1+27.5,
point_balance=point_balance+27.5, last_tran_posted_on={d
'2002-10-02'},
last_tran_posted_at={t '21:16:33'} Where
uuid='23A99597-9F04-11D6-AEAA00A0CC617FCD'
I guess it's too much to ask that they tell me WHAT value is
out of range -
or, since I am now using a real SQL database instead of MS
Access, do I
have to do all the calculations outside of the Update?
Thanks in Advance,
Ed Gordon
=
HERE'S THE CF CODE
=
CFQUERY datasource=#application.ds#
Update MEMBERS
Set status='#STATUSCHANGE#',
current_point_ratio=#RATIOCHANGE#,
total_purchases=total_purchases+#numAmount#,
purchases_this_year=purchases_this_year+#numAmount#,
purchases_quarter_1=purchases_quarter_1+#numAmount#,
total_points_earned=total_points_earned+#numPoints#,
points_earned_this_year=points_earned_this_year+#numPoints#,
points_earned_quarter_1=points_earned_quarter_1+#numPoints#,
point_balance=point_balance+#numPoints#,
last_tran_posted_on=#CREATEODBCDATE(tdazedate)#,
last_tran_posted_at=#CREATEODBCTIME(theodbctime)#
Where uuid='#getmember.uuid#'
/CFQUERY
=
HELP?
TIA
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
