Search results for query: *

I've found that I need to an array and am using the following code <% csv_to_read="HD_Closed.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile("C:\inetpub\wwwroot\Stats\Stats\db2\HD_Closed.csv"(HD_Closed)) imported_text = act.readline 'Read the first line of...

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...

Oh just one more thing... If I want to select a specific daterange how do I do that? Say I only want to show dates between 1/1/2006 and 31/12/2006? Thanks again

thanks for the advise...works perfectly

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...

Alex, Using your code I've now created 2 queries...One for Admin and one for Support... On my Admin and Support pages I have 2 columns, one with the Tech's name and the other with the total calls they have closed. As I mentioned I have seperate pages for both the Admin and Support calls What...

Your suggestion allows me to bring up the query in my webpage Michael but the order is still out..ie the Total's don't flow down the page in order..

That gives me an error No value given for one or more required parameters.

Sorry Alex, just one more question on this (please let me know if I should ask this in the other forum) But how do I order the results by total (i.e best to worst) I tried ORDER BY 'Support' DESC But this does not seem to work?

Thanks so much Alex...Worked perfectly I apologise for posting in the wrong area will make sure I post in Forum701 next time Cheers

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...

It worked using the 'h'... Much appreciated gmmastros and bborissov..

Thanks for helping me with this mate! Still throwing an error though using 'hh' Microsoft JET Database Engine error '80040e14' Invalid procedure call

Hmm no all the field names are correctly listed (although you are correct about the crap spelling :)

Thanks Guys... When I execute the code you suggested rs.Open "SELECT AVG(DATEDIFF(hh, [HPD Opended Date Time], [HPD Resolved Date Time])) FROM HD WHERE [HPD Resolved Date Time] is Not NULL", conn I get an Microsoft JET Database Engine error '80040e10' No value given for one or more...

Thanks Guys... When I execute the code you suggested rs.Open "SELECT AVG(DATEDIFF(hh, [HPD Opended Date Time], [HPD Resolved Date Time])) FROM HD WHERE [HPD Resolved Date Time] is NULL", conn I get an Microsoft JET Database Engine error '80040e10' No value given for one or more required...

Thanks for the responses Here is how I am displaying calling the data from my asp page <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "\\nsyd9009pap\c$\Inetpub\wwwroot\GMS_Stats\Stats\db\Remedy_2006.mdb" set rs =...

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...