Search results for query: *

thought abut that or using right(thefield, 6) but unfortunatly it doesn't work as I am also using distinct in ym sql statement

Hi, I am trying to order items, task 1, task 2, task 20, task 3 in my database using the order by function in my sql statement unfortunatly it orders it as task 1, task 2, task 20, task 3 not task 1, task 2, task 3, task 20 as I want it to. I believe that you cannot use the replace function...

thanks for this - very useful

OK,I understand, so assuming I can copy a vbs or hta file to their PCs (or asked them to download it from my website) how do I go about setting up the automated FTP system for them to browse and upload file (sorry for my ignorance)

we've tried the 'less elegant' option but our partners founf it very difficult to use, especially as the file name they uploaded then had to be copied and pasted to a database update system manually (as opposed to the automatic naming that came with our upload script) hence we are trying to...

Thanks for that, the problem is, we're talking multiple partners and not always on the same PC, + most of them do not want us to install any script on their PCs, so we're talking automated. I have tried our own script for uploading files but it still times out even though I have increased the...

OK, I am trying to setup a script that would allow partners in Europe to upload large (20Mb) files to my website across the web. My hosting company only allows a maximum of 4Mb upload usign upload script, hence I was trying to create an FTP script that would be faster and not restricted to 4Mb

Sheco, the code snippet included was just an example to see if acces was possible. This is not the final code. The final code enables upload from my client server to the web server, but without access to Wscript.Shell it isn't possible anyway. Thanks theniteowl useful ping code.

Thanks for that. I have tried to run the code but I'm told that access is denied

I feared that that would be the case. I am using shared hosting so have no access to the System32 amd FTP executable. I don't presume that there would be anyway of bypassing this?

I have found a solution but having problems with permissions on my shared web server. Here is a snippet of my ASP page. CODE Dim fso, TF, DataFileName DataFileName = "c:\SAMPLE.TXT" FTPFileName = "C:\CMDS.FTP" Set fso = CreateObject("Scripting.FileSystemObject") Set TF =...