Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copying tables between datasources
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 - -
Deleteing all rows in CF/Linux MySQL
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 -
Obtaining screen sizes
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 -
Obtaining screen sizes
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 -... -
single quotes in a query
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... -
single quotes in a query
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!- gm456
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Application.cfm
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... -
Cookies
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><CFCOOKIE NAME="APLPRV" VALUE=#username#><br><cflocation... -
CFFILE copy
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> -
ColdFusion 4.5.x NT vs Linux
On this note, is anybody running CF on a Raq3?<br><br>Garry -
CFFILE copy
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> Unable to copy file 'i:\testdoc.txt' to path 'd:\webroot\users\VIEW_A60D2C.jpg'. Error...
