Search results for query: *

I accidently restored a day old backup onto the my live DB. How can I undo this ASAP???

I have a small (~90MB) database that my production is recorded on and every 5 minutes this info is put into a txt file and sent via FTP to another offsite Server. Then the record that have been sent get flagged. The last couple of days my server timesout on the update and after trying the...

This may be very simple but I can't seem to figure this out. How do I loop/repeat a video in WMP 9 until the user hits stop or changes the video?

I am looking into tracking all the down time that occurs on the plant floor and making it available on our intranet site. I have asked my electricians to wire all the machines up and have connected to a PC with RSLogic and RSLinx. I want to eventually use RS linx or RSview to write machine...

I am not sure if this will be done in PHP be but I want a webpage to be freshed every 5 minutes. Is this possible? If yes, how will I do this. Thanks

I have a page with a form the user fills out (start date and end date). Based on this the SQL 2000 db is queried and the results are graped below the form as an image. I then add a button to dump the raw data that was graphed into an excel file. The problem is that when I send the data to excel...

i have a barcode slot reader with a ps2 keyboard wedge connector. The problem is that I don't want to have a keyboard at the pc. So when the pc gets rebooted the barcode reader doesn't work. Is there any way to get around this? Have I just wasted money on 2 readers?

I have a strange problem on a laptop. I am running XP pro and when the laptop boots up there is an IP address in the Prefered DNS server, alnternate DNS server and default gateway fields. They are 3 different IP address'. The problem is that the user has to clear these adress' everytime the...

i am not sure if anybody here can help me with this but I have an injection moulder running proprietary software on a TWINCAT system. I spoke with rep at twincat and he said that I can potential write a program to read the I/O from the twincat and do as I please with it in my program. i looked...

I am running a windows 2000 server with 2 sesions of Reflection for Unix (Unix connectivity tool). About once a day when a file is being transfered one of the sessions will hang. When I check the file on the unix server the transfer is complete. This causes some problems because once the file is...

this may be a very basic problem but I am just learning. How do I do multiple commands as 1 action? for example @if (condition1; action1; condition2; action2) where action1 is more than one command.

What I am trying to do is determine if the user belongs to a group and then hide a button if they do. right now I have this code in my open query: Sub Queryopen(Source As Notesuidocument, Mode As Integer, Isnewdoc As Variant, Continue As Variant) Dim session As New NotesSession Set db =...

I have a variable called isManager and it is of type variant. I am trying to evaluate it in an if statement @if (isManager = "1";....) How can I do this? I tried converting it to a string but that didn't work. I checked the type using typename and it gave me VARIANT() as the type...

How can I group by date in a query for SQL 2000 and ignore the time. I want to get the total quantity for a day. Problem is that datetime and smalldatetime Which prevents me from doing this. In Sybase I caould convert the data type to a date and that woiuld drop the time. Is there a way to do...

I have the following select statement for my datawindow but powerbuilder won't accept it. I get a message saying that all the columns that aren't computed have to be in the group by clause. If I do this then the sum is pointless. I would like to have the sum in the select statement so that when...

SELECT audit_trail.vendor, SUM(audit_trail.quantity), sdmn.reject, vendor.code FROM vendor LEFT OUTER JOIN sdmn ON vendor.code = sdmn.supplier AND sdmn.day >= '10/01/02' AND sdmn.day <= '10/30/02', vendor LEFT OUTER JOIN audit_trail ON vendor.code =...

In a datawindow I have a datawindowchild that requires an argument. This argument is supposed to be another column in the table (when data is being inputted by the user). When I retreive records from the database foe the datawindow the childdatawindow asks for an argument. How can i stop the...

I get the following error message when I try to execute a stored procedure. What doe it mean. The message comes up at the very beginning where the parameters are being recieved. [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

I have a stored procedure in SQL Server 2000 that basically deletes all the data from a table and inserts some new data into the same table. I call this procedure in powerbuilder 7 and I am passing 2 datetime variables and a string to the procedure (recieved as datetime and varchar(25). For some...

I have a stored procedure that basically delete all the data from a table and inserts some new data into the same table. I call this procedure in powerbuilder 7 and I am passing 2 datetime variables and a string to the procedure. For some reason my procedure isn't executeing. when I run the...