Access Query Question

2007-04-18 Thread dsmith
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

CF MX Access DSN w/o ODBC Service

2007-02-09 Thread dsmith
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 ~|

Really Simple(I think) IIS Issue

2007-02-07 Thread dsmith
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

Re: Really Simple(I think) IIS Issue

2007-02-07 Thread dsmith
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

Re: Really Simple(I think) IIS Issue

2007-02-07 Thread dsmith
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

Re: OT-Image Maps

2007-01-31 Thread dsmith
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

Hosting Suggestion 100 +gigs of data

2006-12-19 Thread dsmith
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?

MX 6.1 Admin Password

2006-12-13 Thread dsmith
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

Re: Web services...SOLVED

2006-11-06 Thread dsmith
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

Re: Web services...

2006-11-05 Thread dsmith
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

Re: Web services...

2006-11-05 Thread dsmith
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.

Re: Web services...

2006-11-05 Thread dsmith
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

Re: Web services...

2006-11-05 Thread dsmith
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:

Re: Web services...

2006-11-05 Thread dsmith
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

Web services Error

2006-11-02 Thread dsmith
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

Re: Web services Error

2006-11-02 Thread dsmith
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]

Re: CFMX 7 ODBC Service

2006-08-03 Thread dsmith
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:

Re: CFMAIL and performance

2006-03-13 Thread dsmith
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

Re: CFMAIL and performance

2006-03-13 Thread dsmith
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?

Re: CFMAIL and performance

2006-03-13 Thread dsmith
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:

Re: CFMAIL and performance

2006-03-13 Thread dsmith
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

Re: CF MX 7 and DB2 connection timeout SOLVED

2006-03-07 Thread dsmith
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

Re: CF MX 7 and DB2 connection timeout

2006-03-03 Thread dsmith
-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

Re: Flash forms checkbox question

2006-02-09 Thread dsmith
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

Re: Pros/Cons Session vs Client scope

2005-11-23 Thread dsmith
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,

Re: Any reason client.LastVisit wouldn't exist in CFMX7

2005-07-27 Thread dsmith
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?

SOLVED: Re: Any reason client.LastVisit wouldn't exist in CFMX7

2005-07-27 Thread dsmith
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

Re: Slightly OT: Dreamweaver Error

2005-05-25 Thread dsmith
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!

Flash Forms in CF MX7

2005-05-13 Thread dsmith
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

dynamic urls

2004-12-09 Thread dsmith
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

Slightly OT: Hosting AV Files

2004-01-26 Thread dsmith
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

DB Connection Timeout

2003-12-17 Thread dsmith
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

Testing DSN's before processing queries

2003-11-24 Thread dsmith
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

CFCookie Question

2003-11-12 Thread dsmith
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

Re:DB2 and Stored Procedures

2003-10-16 Thread dsmith
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]

Weird thing happening with ODBC Datasources

2003-10-16 Thread dsmith
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

Re:Weird thing happening with ODBC Datasources

2003-10-16 Thread dsmith
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

DB2 and Stored Procedures

2003-10-15 Thread dsmith
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