Search results for query: *

Hi everyone, I am trying to display information from a csv file on a website. This is what I have so far...(I know this is wrong, but I've only extracted info from Access databases before using SQL :( ) [code] <% set conn=Server.CreateObject("ADODB.Connection") Conn.Open "Driver={Microsoft...

Hi everyone, Apologies if this is not the correct forum to post this in... I am trying to display information from a csv file on a website. This is what I have so far...(I know this is wrong, but I've only extracted info from Access databases before using SQL :( ) <% set...

Hi, I have a query that is extracting information from an Access DB and displaying it in a table on a webpage set rs = Server.CreateObject("ADODB.recordset") rs.Open "select [TSK Assigned To Individual], sum(iif([TSK Assigned To Group] ='GMS-Admin', 1, 0)) as GMSAdmin from TSK group by [TSK...

Hi, I am trying to extract information from a database using an SQL statement. In this database I have 2 columns HPDName and HPDAssigned. Within the HPDAssigned Column I have one of 2 things, Admin or Support. In the HPDName Column I have the name of the Technician. What I want to show on my...

Hi, I have an access DB which has various information on ticket closures within my department I'm attempting to create a query which shows the average time it takes between a call being opened and resolved using the following rs.Open "SELECT AVG(DATEDIFF(hh, [HPD Opended Date Time], [HPD...

Hi all, Quick (and I'm sure easy) question I have the following script. <script> function Launch_TSC(strServer) { var strServer var strTSCpath = "C:\\windows\\system32\\mstsc.exe /v:" var ws = new ActiveXObject("WScript.Shell"); ws.Exec(strTSCpath + strServer); } </script> I then use...

Hi all, I am trying to create a form where if a user chooses either the Yes or No radio button they are prompted to complete different fields before submitting the form...The following is the Javascript section of the code <script type="text/javascript">...

Hi all, I have successfully been able to write queries pulling information from an Access Database and displaying it in a table on an ASP page....(locally in the wwwroot dir of my PC) I have just uploaded the files to an internal server (intranet) where they will reside and am now getting the...

Hi all, I'm trying to display records from a MS Access DB in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year.. Joe Bloggs ---> 100 Closed...

Hi All, I've been searching through this forum (very informative btw) and am hoping that someone can shed some light on a question I've been trying to answer for days... The problem: I'm trying to display records from an access database on an ASP page! However, I want the records to show as a...