Search results for query: *

I have this query that is in a Stored Preocedure. I want to be able to call this stored procesure with different variables. Problem is that is will not compile with a variable in the From statement. I keep getting a message that the variable must be decared but that is strage because I have...

OK i am still new at SQL and my probelm is that when I divide Minutes by 60 (I.E. 458 minutes divided by 60 should return 7.63 hours) However When I do SUM(MINS)/60 I get 7. I tried CAST((SUM(MINS) / 60) as float) As hours and I still get 7. Can anyone tell me how to get SQL to return 7.63...

Ok so I have a simple fuction. All I want to do is convert all . to / doesnt seem to work very well here goes function DoThese(date_field) { if (date_field.indexof(".") != -1) date_field = date_field.replace(".","/"); validate_date(date_field)...

Ok this one has been meking me crazy. I have three dates dtmDate1 dtmDate2 dtmDate3 What I want to do is find the min date and the max date of the three dates that are available. All three dates are stored into seperate variables and my understanding is that the Min and Max functions only...

I am new to javascript. What I want to do is not allow the user to enter a date that is greater than 90 days in the past. I have written the following. doesn't seem to work. Can you tell me what I am doing wrong <script type=&quot;javascript&quot;> function verifyDate(field) { var today =...

I'm not really good with javascript. I have a asp based site that uses session variables to track the current user. Problem is that after 20 minutes the session variables expire. I want to find away to alert the user to re-logon. My current test code will redirect the user but it does not...

Hi, I have created a small function that should update an SQL table based on a local table stored in Access. Problem is I cannot get the function to recoginize the local table as a valid table. Any help is apreciated here is what i currently have Public Function UpdateAetnaSource()...

Is it possible to get data from the querystring in Javascript? Something like if (<%Request.Querystring(&quot;ID&quot;)%> == &quot;99999&quot;) { document.getElementsByTagName('DIV')[0].style.visibility = &quot;Visible&quot;; else document.getElementsByTagName('DIV')[0].style.visibility =...

I am trying to run a query in Access that will update an SQL table, Which I know I can do. Problem is the query always asking for the DSN. It is my inderstanding that if I run the Query in VBA then I can code the ADODB connection string. I know how to do this in ASP but VBA is different...

OK I know that it is considered bad form to return more than one value form a function but here goes... I have two functions that seems to be redundant. My goal is to calculate the actual fiscal year start and stop dates. here is my current functions <% Public Function FiscalStart() If...

Does anyone know of a script that will change the value of all Drop Down Menus when the User Selects a Change All Button?

I continue to get a type mismatch error and I cannot seem to understatnd why. I am calling this function from a macro. Any help is much appreciated. Here is my code Function SendMail(expr1 As String, strMessage As String) Dim dbs As Database 'Holder for database to be...

I have experience with VB and a little SQL but I have very little experience with Stored Procedures. I have a query in MS Access that formats information from one SQL table to another SQL table. Problem is that I am working with about 300,000 records in the original table. I know that if I...

I have an entry form that the user can enter new data. I have written code to validate the entry of one field. The code does give a message if the user enters a value that has already been entered into the database. The Problem I have is that it will not set the focus back to the field and...

I want ot know how to get the value of an option button without submitting the form. Thanks