I have a query i use in access that looks like this,
DateAdd("s",dbo.scheduling_timerange.begintime/1000,#1/1/1970#)
when i use it in MSSQL it throws and error at the #
what i am attempting to do is convert a bigint to a date time
in MS ACCESS i run the query on
1210164900000
and i get...
I have a query I am attempting that allows a manager to hover on an icon and see who the last assigned user to a patient was, I am nesting a loop inside a loop, it works but only on the first result... I have done this in the past and had it work fine but cant seem to see my mistake here.
the...
Hi all,
i am trying to make an array that looks like this ...
40,55,40,55,56,122,652,37
i can create 40,55,40,55,56,122,652,37, with an echo.
I have always echoed for html, now i need to store the 40,55,40,55,56,122,652,37, then i was going to use sub_str() to remove the last comma.
the...
Hello,
I am trying to come up with a way in Mysql to use a stored procedure to connect to our web database and update table in our internal database. I have php script that does it now once a day
What i would like to accomplish is sweeping our WEB DB every Five minutes to grab new leads. Is...
I am not very fluent in VB, I have the following macro for drawing points in the cam program I use to program wire EDMs
Sub cdb()
'Macro Recorder 8/31/2007 by Mike
On Error Resume Next
'Declare the variables
Dim App As Esprit.Application
Dim doc As Esprit.Document
Dim...
What I was wondering was, Is there a way to use the .htpasswd and not effect internal connection? I want to make some of our Intranet available so folks can work from home. I already use php with a login system, but I was hoping for a little extra security when coming from the outside by adding...
I have a database that grabs input from a website. The form on the website has poor validation so I get various types of entries for phone number. some of these formats.. 1 (222) 333-4444, 12223334444 1.222.333.4444 1/222/333/4444 .. you know... That Ol' chestnut!! I have even seen...
I have seen many ways to do this, but am not fluent in functions, can someone step me thru how to do this? I want to check and see if the Table leads and leads_ImportErrors exists and if so drop them
Thank you for any help
Mike
I have a CSV file that has always worked but recently the file we were getting was changed to have " " around the text fields, Now its also adding \"data|\" in some places... access is ignoring anything after the first "\.
I cant seem to find anything in access to get around this, Any ideas...
Is there a way to combine multiple php files into one file and then call the functions from a main page? I have some menus embedded in a layered form, As it is I have a menu_layer1.php.. menu_layer2_.php and so on... I was sure there was a way to call the file something like include...
Has anyone used Qforms at all? its a very nice form app that will allow posting multiple layered forms, but I am a java newb and was wondering if anyone has dealt with it.
regards
mike
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.