Recent content by dhar2611

hi guys, I would like to add a weather report on my website. Can u please suggest a website where I can get this feature. Cheers Dave www.ezyguide.com.au

I am using sql server 2000. Where can I get more information on it.

Hi Guys, Just a quick question? In my work they're asking to use charts to produce reports etc. But I have no clue where to start. Any help would be appreciated. Thanks Dave

Hi Guys, I am new to this section. Can you please give me a step by step guide on How to use SSL with ASP? Help would greatly appreciated. Thanks Dave

Thanks for all the information.

Also another question. If I use "group by" will it be a problem.

I just copied your code and pasted on the MS Access query and it gives an error "Missing Operator". Does this mean it works only on the sql server and asp scripts. Thanks for all the information. Many Thanks Dave

yes. Thanks

I have modified a bit of the SQL. I am trying to retreive all the business type from the system. When they enter the keyword I search for those records and display on the screen. I have to group them and display on the screen. sql = "SELECT BusinessType as Type" sql = sql & " FROM tblBusiness"...

Here is my sql statement on my asp page sql = "SELECT BusinessType as Type" sql = sql & " FROM tblBusiness" sql = sql & " WHERE tblBusiness.BVerify = 1" sql = sql & " AND tblBusiness.BDisabled = 0" sql = sql & " AND tblBusSubType.BActive = 1" sql = sql & " GROUP BY SubTypeID" sql = sql & "...

Currently I am running the code on a asp page. Is there anyway I can apply this code in my page. Dave

So I should try this on the sql server as a procedure. Can this be tried as vba or asp code. B'coz it keeps giving error. Thanks Dave

Hi vongrunt, I read your code select blah blah, case when <col> like '%computer service%' then 2 when <col> like '%computer%' and <col> like '%service%' then 1 else 0 end as relevancy from myTable where <col> like '%computer%' OR <col> like '%service%' order by...

I got a idiotic question. in ASP I am doing a key word search using sql statement. For example: search for "computer".... results is fine. It gets only the records with the keyword like "%computer%" search for "computer service"..... results comes out but not the way I want. my sql...

Hi Guys, I just found out my web host company uses only ASPSimpleUpload component. I cant find any help for this. Can any guide me. I got a simple example to upload file. But I need more help with finding the file size and file type etc. Can anyone help. Thanks. Dave