Search results for query: *

I'm currently using Version 4.0.20-a and am migrating data from a Sybase Adaptive Server Anywhere V7 database. I've managed to import the data OK, but my problem now is the different sytax on existing queries. I've searched the MySql manual without success on this one and need help! The site...

Hi, We have a problem where the date and time has been set on our on our Windows 2000 Server but on our web pages (both Cold Fusion and ASP) the date is read from the database in US Format (MM/DD/YYYY). I've made changes to "Regional Options" under Control Panel [General Tab - Locale...

As I understand it, Cold Fusion Server can "natively" run MS Visual Source safe as Version Control software allowing a team of Developers to share files, etc. This works hand-in-hand with CF Studio allowing people to "Check In" and "Check Out" files to work on. Is...

Hi, I'm attempting to unzip a file on the webserver using a Winzip patch "WZUNZIP". It works perfectly in a batch file when running it from the command line on the web server. I am required to run it it as a CFSCHEDULE but have found that the path name is a problem: D:\program...

Has anybody else installed the security patch that this Security Bulletin refers to? We run Win2K server, IIS 5.0 and CFusion Server 4.5.1. Upon installing the Security Patch, we found that the server then required everbody who visits the site to enter a username and password! The patch makes...

I'm attempting to import a CSV text file once a day at a specific time by using an Event. The following works perfectly in Interactive SQL: INPUT INTO dba.myTable FROM C:\\myDirectory\\fred.txt FORMAT ascii; Works like a charm! I've since read in the documentation that INPUT is a command...

I have a list which is added to every few days. The addition date is auto inserted into the database. How can I list the new additions for the past 7 days? <p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a...

Hi, I have some comma delimeted text files from which I need to run various queries. My only problem is that they don't have the field names on the first line! I've checked the CF documentation which suggested something like this: <CFHTTP METHOD=&quot;Get&quot...

I've got an application which shows each employee's area of specialty (some have 2 or 3).<br><br>At present I'm using a Multiple select box which seems to work well when recording the information.&nbsp;&nbsp;When an employee tries to edit their information, only one specialty shows as...

I've got both Ben Forta books and have managed to work my way throught the WDDX examples successfully.<br><br>My question is this:<br><br>The company I work for publishes information using XML files.&nbsp;&nbsp;How do I convert an XML file to WDDX?&nbsp;&nbsp;Do I need to?<br><br>Please help...

I'd like to format numbers as phone numbers.&nbsp;&nbsp;For example 1234 456 789.&nbsp;&nbsp;My problem is the using #DateFormat(&quot;9999 999 999&quot;)# doesn't work.&nbsp;&nbsp;<br><br>The data is stored as 123456789. I've tried storing the numbers as text or numbers on various occasions...

I'm attempting to 'grab' a .html file from another server that has an applet contained on it.&nbsp;&nbsp;I need to resolve URL's when using the file as it has a number of dynamic links on it.&nbsp;&nbsp;Everything works fine except for the Java applet.&nbsp;&nbsp;I've changed the &lt;applet&gt...

I just got the following error:<br><br>Error Diagnostic Information<br>ODBC Error Code = S1000 (General error)<br><br><br>[Microsoft][ODBC Microsoft Access Driver] Object invalid or no longer set.<br><br><br>Data Source = &quot;tolhurst_passwords&quot;<br><br><br>The error occurred while...