Search results

Hi All, Is there any way I could configure this forum in my Outlook Express using NNTP? If yes, Can I have NNTP Server Address? Many Thanks in advance, Jigs :)

Hi All, I have one serious emergency. I have 2 options (2 qeustions) in front of me. [1] How can I remove primary key and not the column [2] How can I rename the column which is primary key. Please help me. Thanks in advance Jigs

Hi All, I have 2 tables in my website project. [1] Country - which consists of fields like Zonecode, countryname, locations as shown below: ZoneCode Country Locations ------------------------------------ Zone1 Australia LocAus01 Zone1 Australia...

Hi All, First of Sorry, becuase I am posting off topic. I have 2 databases. One in Access and another in MS SQL Server 2000. DTS Import Export wizard transfers the data between Access and SQL Server well. I am able to get the SQL Scripts for "Create Table", but How to get the SQL Script for...

Hi All, When I try to edit the existing .cfm page and view it in browser, it gives me the following error. Index 113, size 69 Can any one please help me to sort this problem? Thanks in advance, Jigs

Hi All, I have a field named "PICK_DATE" in text format where pickup date is stored in DD/MM/YYYY format. Now I wanted to generate a report with the order by clause of PICK_DATE. But it is not giving me the desired result. I want to see the latest PICK_DATE at the top of the report in...

Hi All, I am using the following query to retrieve sum of gross total and nettotal : where PICKMONTH and PICKYEAR are the pickup month and year of the travel. The above query doesn't execute and give error as following Please help me Jigs :confused:

Hi All, I have a fields "ARRIVAL_DATE" in which arrival date is stored. This fields is text field in which date is stored in DD/MM/YYYY format. Now, I want to search by ARRIVAL_DATE which falls in between perticular date bounds using between but I am not able to do so. I am not getting the...

Hi All, I have 2 tables. [1] AvailableCars [2] CarPics [1] AvailableCars consists of fields as Zone (eg. ZoneA, ZoneB, ZoneC) , CarCategory (eg. CarAA1, CarAB1, CarAA2 ... and so on), DailyRates, and Valid DateBounds (FromDate, ToDate). [2] CarPics consists of CarCategory and Carpicture (Path...

Hi All, Can any one will be able to explain me "What is the key attribute in Data Modeling ?". :o Thanks in advance, Jigs

Hi All, I m using MS-access as backend and I am using the following query where I use FIRST() as aggregrate function. SELECT FIRST(COUNTRY) AS FIRSTOFCOUNTRY, ZONECODE FROM LOCATIONS GROUP BY COUNTRY,ZONECODE HAVING ZONECODE = "ZONE01" Now I have to shift my access database to SQL server...

Hi All, I have one table where ID field is autogenerated, and another field orderno which is not primary key. Now it has 2 duplicate values in it so when I try to make field Orderno as primary key, it is not allowing me to do so. Can any one help me how to find the duplicate values using...