Access Query Question
I have a client using access (I know Access sucks for web stuff, but he's using
it...) Anyway I try to execute the SQL below and it blows a syntax error from
CF. I can paste this into a query in Access and get it to run. I think it has
something to do with the field called Date which is a text field.
INSERT INTO Reports_Items_Viewed (ItemNumber,[Date],Type,Count,PageCount)
VALUES('103','2007-04-18', 'collection' , 1 , 1 )
Any help would be appreciated.
Daron Smith
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275816
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF MX Access DSN w/o ODBC Service
Is it possible to create an access datasource on 6.1 w/o having the ODBC service running? There appears to be an access native driver but when I try to use it it tells me that the ODBC service isn't running. Thanks, Daron ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Really Simple(I think) IIS Issue
We recently configured a new server, windows 2003. We can get IIS to serve even basic htm pages. The file system and web security on the folder is wide open and still nothing. If I type localhost:80 it does bounce back to localhost w/o the :80. I'm sure that there is something simple that we're missing but we can't seem to see what it is. All of the IIS and WWW services are running. Anyone have any ideas why this isn't working? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Really Simple(I think) IIS Issue
We recently configured a new server, windows 2003. We can get IIS to serve even basic htm pages. The file system and web security on the folder is wide open and still nothing. If I type localhost:80 it does bounce back to localhost w/o the :80. I'm sure that there is something simple that we're missing but we can't seem to see what it is. All of the IIS and WWW services are running. Anyone have any ideas why this isn't working? I should have said we CAN'T get IIS to serve even basic htm pages. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Really Simple(I think) IIS Issue
Assuming that We can get IIS Should have been We can't get IIS You probably have the default website listening to localhost, try stopping the default website, or setup the other website to listen to specific hosts, like www.yourdomain.com and browse that. Regards Dale Fraser We couldn't get the url site to come up, so we tried just using localhost and that doesn't work. Something is preventing IIS from serving pages. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT-Image Maps
That wouldn't be an image map then. At that point, you could use CSS to draw rectangular areas and make them links. If you just want to show the borders of the area, then make that your image. Just the borders. andy Can I use x,y coordinates to draw a Polygon with CSS? I really want to render a dynamic map without images. I have the x,y coords but want to shade individual regions based upon query results. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Hosting Suggestion 100 +gigs of data
Hello, I'm working with someone on CF site. He has his own server but really should be hosting his site somewhere. It's a video site with over 100 gig of data. Is there a good host out there who would host his without charging an arm and a leg? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MX 6.1 Admin Password
I'm kind of stuck with an admin password. I lost the password so I went into neo-security.xml to turn of the password. But when I go back in and try to enable it through the admin it throws me to a logon screen as soon as I click the enable password checkbox. I haven't reset the password yet so I can't get back in. I cycle CF service and the admin starts again w/o a password. Anybody have any ideas how to get the password to stick? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web services...SOLVED
This problem appeared to be related to DNS. It seems that CF had an old address cached. I restarted CF and it now works. Grabbing the WSDL with CFHTTP is a great idea to see what CF is seeing. Many thanks for everyone who helped out on this. I can get call it from the server (IE) and get it to work. Don't think we have HTTP proxies. What do you get if you use CFHTTP to fetch and display the WSDL? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web services...
It seems to be working for me. Do you have debugging turned on or something similar, that would create extra output? --Ben Smith, Daron [PA] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web services...
I can get call it from the server (IE) and get it to work. Don't think we have HTTP proxies. Anyone have any ideas why it's complaining about an hr tag there's none anywhere that I can find? I've googled this to death and can't seem to find anyone who's resolved this type of error. Presumably, something is returning an HTML page to CF. What happens if you go to the server console and request the URL directly? Do you have HTTP proxies set up in your environment? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web services...
It seems to be working for me. Do you have debugging turned on or something similar, that would create extra output? --Ben Smith, Daron [PA] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web services...
I have turned off debugging in cfadmin. Is there a way to force no other HTML to be rendered? Some directive like suppress whitespace? It seems to be working for me. Do you have debugging turned on or something similar, that would create extra output? --Ben Smith, Daron [PA] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web services...
I should also add that when I try to configure it in CFADMIN it will not establish. I've also tried calling it from CFSCRIPT. Anyone have any ideas why it's complaining about an hr tag there's none anywhere that I can find? I've googled this to death and can't seem to find anyone who's resolved this type of error. Presumably, something is returning an HTML page to CF. What happens if you go to the server console and request the URL directly? Do you have HTTP proxies set up in your environment? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Web services Error
I get the following error when trying to consume a .Net web service on another web server. I can call the wsdl and get it from the web server. I can also use the .Net server to call it and it works fine. Any thoughts? org.xml.sax.SAXException: Fatal Error: URI=null Line=20: Open quote is expected for attribute width associated with an element type hr. It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. Thanks, Daron Smith ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web services Error
Yes if I call the wsdl from a browser I get an XML page. When you say I can call the wsdl and get it from the web server. Do you mean, you type the path of the web service into your browser with ?wsdl after it and you receive xml? ~Brad -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 02, 2006 12:57 PM To: CF-Talk Subject: Web services Error I get the following error when trying to consume a .Net web service on another web server. I can call the wsdl and get it from the web server. I can also use the .Net server to call it and it works fine. Any thoughts? org.xml.sax.SAXException: Fatal Error: URI=null Line=20: Open quote is expected for attribute width associated with an element type hr. It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. Thanks, Daron Smith ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX 7 ODBC Service
Smith, Daron [PA] wrote: We are having lots of trouble with the CF ODBC service locking up. Reading about it on the Adobe site they say that it's not really necessary. But if I stop it, my ODBC queries do not work. What do you use for database access if you disable that service? JDBC: http://livedocs.macromedia.com/coldfusion/7/htmldocs/1735.htm#1235436 Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMAIL and performance
i write every message i want to send to a db. then i loop through the database 5 at a time, and send them. each has its own unique message id and for each one that sends out without error, i mark as sent. then i go back over the ones that are not marked as sent and resend. anything over 4 retries, dies. tw On 3/13/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235277 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: CFMAIL and performance
Do you trap for errors? What happens when if/when you encounter an error? I ended up looping through my set, sending 1K at a pop with each cfmail. This gets out groups of about 1 in less than ten minutes (mailserver bottleneck), and hardly hickups the cf server at all. performance? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235280 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: CFMAIL and performance
What happens if you encounter an error? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235281 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: CFMAIL and performance
What's the biggest distribution you send with this method? Seems like a lot of roundtrips to the db? Does it perform well? i write every message i want to send to a db. then i loop through the database 5 at a time, and send them. each has its own unique message id and for each one that sends out without error, i mark as sent. then i go back over the ones that are not marked as sent and resend. anything over 4 retries, dies. tw On 3/13/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235284 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: CF MX 7 and DB2 connection timeout SOLVED
Unchecking the 'Maintain Database Connnections' check box seems to have fixed the problem. Our AS/400 was unavailable for a significant time this w/e for an offline backup. In the past this would have definitely killed the datasource. But Monday morning everything was OK. We recently moved our web site to a CF MX7 box. Ever since we occasionally get the following error Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The iSeries server application disconnected the connection In the log files this is always preceded by the following error message Error,jrpp-1375,03/02/06,19:01:00,PSEA,Error Executing Database Query.Timed out trying to establish connection This message happens 1-4 times and then the ODBC driver is unavailable until I restart the CF ODBC Server. Has anyone else experienced this scenario on CF and DB/2? Is there a way to automatically restart the ODBC server when this happens. Or is there another solution to resolve this issue? Even verifying the datasource in CF admin fixes it. It seems to be that CF stops trying if it gets the timeout message until the ODBC connection is refreshed? Any thoughts would be appreciated. Daron Smith PS I think my boss is thinking this is a good justification to go to .Net ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234481 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: CF MX 7 and DB2 connection timeout
-Original Message- I'm a little confused why'd you'd be using the ODBC connection for this - isn't there a Native (type 4) driver available from IBM? The same driver available for WebSphere should work just fine with CF and you'll get a lot more support from IBM. There is a generic DB/2 driver available in the CF admin but we can't seem to make a connection with it, we get a connection refused error message. Is the driver in the CF admin the one you're referring to? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234074 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: Flash forms checkbox question
Hey, thanks for being a member! I'm looking to do a DB update, I was using CFUPDATE, which automatically converts true/false to 1/0. CFUPDATE doesn't seem to work with this table on our database, so I was trying to write the SQL and having T/F in the form variables blows up when it hits our bit field. Hey, I'm a PSEA member! Just got certified to teach English, planning ahead for the day when nobody will hire me as a developer anymore... What about creating a UDF that converts a true/false to a 1/0? What are you doing, inserting the data into a database as individual values, or are you doing something else with the structure? Pete On 2/8/06, Smith, Daron [PA] [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231740 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: Pros/Cons Session vs Client scope
Nathan, You raise some good points. In your opinion if I'm not running in a clustered environment, are session variables the way to go? Anyone else have thoughts? I wrote something on client variables a little while ago: http://www.dopefly.com/techblog/entry.cfm?entry=77 It's a good read, with some good comments too. -nathan strutz http://www.dopefly.com/ On 11/23/05, Smith, Daron [PA] [EMAIL PROTECTED] wrote: ~| 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:225076 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: Any reason client.LastVisit wouldn't exist in CFMX7
Did you disable global client variable updates? No I didn't. I'm using the following code which works on our CFMX machines. CFIF DateDiff(n, Client.LastVisit, Now()) GT 15 and I get the following error. Element LASTVISIT is undefined in CLIENT. Any thoughts? ~| 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:212977 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
SOLVED: Re: Any reason client.LastVisit wouldn't exist in CFMX7
I restarted the CF server and client.lastvisit exists now. Not sure why it didn't before but I may just have to chalk this up to that very precise designation of a Fluke. ~| 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:212987 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: Slightly OT: Dreamweaver Error
Before going to install the app from scratch, you could first try deleting your local configuration folder. To locate the folder follow this technote: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16420 This worked, thank you! ~| 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:207654 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
Flash Forms in CF MX7
I just installed CF MX 7 and wanted to try out the flash forms. I tried using the code below: cfform action=xxx method=post name=form1 format=flash cfinput type=submit name=Submit value=Submit name: cfinput type=text name=text p password cfinput type=password name=text value=bob /p pbr cfinput type=submit name=Submit value=Submit /p /cfform When i call the page nothing but blank space appears, when I right click I get a 'Movie not loaded' Flash player text. Is there something on the server not installed correctly? I did a standard install. Or is there something wrong with the above code? Thanks, Daron Smith ~| 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:206605 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
dynamic urls
This is slightly OT but I'll shoot anyway. We're looking to create web sites for approx 1200 afilliated organizations. The sites would all be run using the same CF templates. It would be very nice to have a virtual directory for each or else a unique URL for each. Is there a way to have IIS look at a database rather than create a real virtual directory for each? Or is there another way to create an easy URL and avoid the following http://verylongsitename.org/local_content/page.cfm?ID=1033 ? Any thoughts would be appreciated. Thanks, Daron Smith ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186796 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
Slightly OT: Hosting AV Files
I've been asked to find out how hard it would be to make some digitally recorded audio and video available for downloading on our site.Does anyone have any suggestions on software, both to get the files ready to download (editing, etc.) and serving software on the webserver.We use IIS, do we need anything else to serve up the files?Any suggestions for a good how-to reference? Thanks, Daron Smith PSEA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DB Connection Timeout
We use Client Access to connect to a DB/2 400 database.However when the AS/400 is down for maintenance attempts to connect to that machine eventually lock up the CF server and I need to restart it.I've tried a CFTRY, CATCH but the connection doesn't return an error it just hangs.Is there a way to force the operation to quit if it isn't done in a specified amt of time?I've tried using the CFQUERY timeout attribute, as well as the CF Admin DSN, the Client Access timeout settings to no avail.Whenever the 400 is down (usually overnights, and weekends) our webserver crashes, so I need a way to not make the DB calls if the 400 is down. Thanks for any ideas, Daron Smith [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Testing DSN's before processing queries
Does anyone know a method to test a DSN before running a query?We link to an AS/400 DSN which is occasionally offline for backups, maintenance, etc.I'd like to run a test that if the DSN isn't working will display a Please come back later message.Any suggestions? Thanks, Daron Smith [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFCookie Question
I need to set a cookie with a name of WB-Pass.Apparantly CF 6 doesn't like the special character -.This works in CF5.Does anyone know a way to use CF to set the cookie or do I need to use _javascript_ or ASP. Thanks, Daron Smith [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:DB2 and Stored Procedures
is this an RPG/Cobol Stored Procedure... No it was created with SQL according to my 400 guy?Can those procedures be called using the cfstoredproc and cfprocparm tags? We're looking into creating it with RPG though...Is that our best option? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weird thing happening with ODBC Datasources
This is totally weird.But what seems to be happening is that if an ODBC Error is generated by one page anywhere on my server, any other ODBC calls will generate the error messagefor that first page that caused the error.Yesterday it crashed the server.However, once I run the page that caused the error with the error removed, everything works fine.It doesn't matter what kind of ODBC driver it is, I've done it with Client Access, Rumba and SQL Server.I'm running CF 5. Has anyone ever seen something like this? Daron Smtih PSEA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Weird thing happening with ODBC Datasources
Yes, I believe what you are saying is correct.I generate an ODBC Error on one page (call it test.cfm), then I call another page (page2.cfm) that has an ODBC call on it, the query from test.cfm will appear with the error message on Page2.cfm.To fix the problem, if I remove the query from test.cfm and call a blank page (test.cfm) the problem goes away.Totally weird... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DB2 and Stored Procedures
Does anyone have any samples of a stored procedure call to DB2 on the AS400 with parameters?I seem to be getting the procedure to run, however, I'm not getting any results, therefore I think it's not taking my parameters.We can get the procedure to work using the same parameters inside of an RPG program. Thanks for any help, Daron Smith PSEA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
