Search results for query: *

I have two vbs files that run and transfer data into a database. I need to create a batch file in ms-dos which is set up in scheduled task to run every night at 1am. How?? I need to know what to write in the blue screen editor for the batch file

I am copying data from a access table into a sql table using a vbscript as shown below in BETWEEN THE *****. When executing the script the script performs some data format changes. as the date fields are split into a logon date + time and logoff date + time. The problem i have is that the time...

I have a table which has imported data thru the use of a vbscript. I have a time field for logon_time and logoff_time. The problem is that a time for eg: 07:09:50 being 7am 9 min and 50 sec is being truncated to 7:9:50. so all leading zeros are removed. I HAVE BEEN TOLD THAT CStr function will...

I have a table which has imported data thru the use of a vbscript. I have a time field for logon_time and logoff_time. The problem is that a time for eg: 07:09:50 being 7am 9 min and 50 sec is being truncated to 7:9:50. so all leading zeros are removed. I HAVE BEEN TOLD THAT CStr function will...

Hi all. Am new to this site and to SQL so treat me with !!! I have imported data from a MS ACCESS file. Not all of the data from the MS access table has been transfered to my sql tables. Septemebers data does not appear at all and Nov and Dec's data only shows data from 1st - 9th december ...

I have been asked to create a XML specification and suprise suprise i dont know how to!!!!!!!!!!!!! Can anyone suggest any Templates, websites or advice on how i should do this and what needs to be included. I have searched on google looking for xml spec documents but cannot find anything...

HI BELOW IS A CODE I HAVE WRITTEN WHICH DOES NOT SEEM TO BE WORKING. I CANNOT IDENTIFY ANY PROBLEMS WITH IT, CAN U !!!! CHEERS FOR ANY 1 WHO CAN sorry i put in the whole code as i aint got a clue where the error is coz the thing is no error comes up when i run it but it doesnt update the...

HI BELOW IS A CODE I HAVE WRITTEN WHICH DOES NOT SEEM TO BE WORKING. I CANNOT IDENTIFY ANY PROBLEMS WITH IT, CAN U !!!! CHEERS FOR ANY 1 WHO CAN PAMO HERE IS THE CODE COPY AND PASTE IT INTO NOTEPAD OR SOMETHING: dim varLOOP dim Sqlstring dim SqlInsert dim Conn dim Rs dim ConnWrite dim objcmd...

I have some tables in Internet Explorer 5.5 . Which i want to copy and insert into a oracle table on a database server. From here i want to be able to access the table and perform checks on clients. Once i have done this i would like the information to be copied back to the web page and sent...

I need to copy a internet explorer html file which includes a table into a oracle database. I need to create a visual basic front end that will allow me to copy the details from a table and automatically insert this copied view into a oracle database. If anyone can provide any suggestions...