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...

This may do the trick! SELECT whatever, visitID, patientName FROM tablename ORDER BY visitID LIMIT 1 Peter Toby webmaster@petersweb.net http://www.petersweb.net ICQ UIN: 1237906

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...

Thanks iza - i'm pretty familiar with with sourcesafe. What i'm looking for is an alternative to Source Safe. Peter Toby webmaster@petertoby.com.au http://www.petertoby.com.au ICQ UIN: 1237906

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...

Sometimes when viewing the source of .cfm files from the web I'll find that if the programmer has used many <CFIF>'s in the code it'll leave blank spaces where the alternative code would have appeared. Perhaps this is what you are referring to? Peter Toby webmaster@petertoby.com.au...

Yes....I tried that with the same result :( Peter Toby webmaster@petertoby.com.au http://www.petertoby.com.au My site is under construction but getting better!

Hi, I'm attempting to unzip a file on the webserver using a Winzip patch &quot;WZUNZIP&quot;. 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've used some javascript code I found at http://javascript.internet.com to do exactly what you're asking!. It's called &quot;Country Chooser&quot;. I've adapted it to run Cold Fusion queries to populate the select boxes and it works a treat! Hope this helps. <p>Peter Toby<br><a...

Thanks giahan, That did the trick! You're a genius!! Thanks to SimonA for your help too. <p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=http://www.petertoby.com.au>PetersWeb</a><br>My site is under construction but getting better!

Thanks Simon, Sorry, I should have said that I'm using MS Access. <p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=http://www.petertoby.com.au>PetersWeb</a><br>My site is under construction but getting better!

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...

Trevor,<br><br>Visit my site (<A HREF="http://www.petertoby.com.au" TARGET="_new">www.petertoby.com.au</A>) and click on the Cold Fusion link (at the top of the page).&nbsp;&nbsp;You'll find heaps of Links to Cold Fusion sites some of which will be a good starting ground for you.<br><br>...

Dave,<br><br>I've found that if you create a file (I call it &quot;breaklock.cfm) which tries to access a table which doesn't exist in the datasource, this releases the lock (and gets rid of the .ldb file).<br><br>Try it....it works!! <p>Peter Toby<br><a...

I'm also having problems with this.<br><br>I've got everything set up as you (DarkMan) suggested in your posts on April 27 and May 31 (including &quot;?cfid=#cfid#&cftoken=#cftoken# with all links), but I still get the &quot;An error occurred while evaluating the expression...

I've tried and failed.&nbsp;&nbsp;<br><br>The XML file I has contains many more of the following:<br><br><br>&lt;mynews title=&quot;Top_Ten_News&quot; date=&quot;20000614&quot;&gt;<br> &lt;news&gt;<br> &lt;author&gt;Mark Todd&lt;/author&gt;<br> &lt;articleid&gt;2000061401&lt;/articleid&gt;<br>...