Recent content by Richo1980

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 :)