Search results for query: *

Is there a simple way of moving a table between different databases on MySql? Basically, I want to split one database into two or three, and place various tables into each. TIA GM -

Bad hair day... whats the syntax to remove all records from a table (I was using delete * from tblname on the NT box but it doesn't work with MySQL) TIA GM

I've sort of answered this one myself - cf_browserhawk is a plug in that gives you this facility, although I'd still like to be able to do it without third party products

I'm using JavaScript in a couple of places to allow me to define a screen size in forms (example below) but can I get this variable somehow into CF? Eg, it the resolution is set to 800x600, the intro screen should only display 2 columns, if it is 1024x768 I can use three columns. TIA gm456 -...

How can I get an SQL query to work on a name that includes a quote mark - eg: form.name contains o'donnell SELECT * FROM people WHERE name like '%#preservesinglequotes(form.name)#%' No matter what combination of single or double quotes I try, it ain't working, with or without preservesingle...

How can I get Access to perform a SQL query on a name that includes a quote mark - eg: SELECT * FROM people WHERE NAME= >> o'donnell << that! No matter what combination of single or double quotes I try, it ain't working. TIA guys!

I have two very similar web sites running off the same server. Both have an Application.cfm file in their root directory with a couple of CFSETS indicating exactly which site is which. The shared .cfm files are in a virtual directory called 'shared', running IIS on NT4. On a file in the root...

I'm setting up a system whereby when a user sucessfully logs on, a cookie is set which is used later on to show extra fields etc. on a search form.<br><br>After validation:<br><br>&lt;CFCOOKIE NAME=&quot;APLPRV&quot; VALUE=#username#&gt;<br>&lt;cflocation...

The only problem I had with UPLOAD is when the desination file already existed and was read only.<br><br>I've tried mapping the server to a driver letter, and using the standard \\servername\pathetc - neither work :-(<br>

On this note, is anybody running CF on a Raq3?<br><br>Garry

I am trying to use CFFILE to copy an image file from a central file store on the network to the web server, so it can then be sent to the browser requesting it.<br><br>All I get, however, is<br><br>&nbsp;Unable to copy file 'i:\testdoc.txt' to path 'd:\webroot\users\VIEW_A60D2C.jpg'. Error...