Search results

It is possible if u r using CFML Hi, Well It is possible to export the report of MS-ACCESS to MS-Excel if u r using Cold Fusion. Check the following sample code: <cfquery name="qry" datasource="mydsn"> SELECT * FROM MYTABLE ORDER BY ID </cfquery> <cfheader name="Content-Disposition"...

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

I mean using SQL Query I want to remove primary key constraint using SQL Query and I also wanted to rename the column which is primary key using SQL query.

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

No Relationsship Hi, There are no relations ship between the tables. There are total 1800 to 2000 records in both the tables. I am not suppose to make any relationsship between any table. Please help me in solving this query without using relationship.

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

yes A .cfm page .cfm page is Cold Fusion page

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

it gives Invalid Use of Null I am using the following queries: SELECT ORDERNO, ORDERDATE, CDATE(PICK_DATE) FROM TRAVELS ORDER BY PICK_DATE Above query doesn't give the desired result. But when I use SELECT ORDERNO, ORDERDATE, CDATE(PICK_DATE) FROM TRAVELS ORDER BY CDATE(PICK_DATE) it gives...

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

Shane, make another table which will consists of the names of the other 4 tables. then from your programming language make a query for searching which loops over the fields of the table which consists of the tables name with preserving the quotes for the search criteria. Try it, if it can help...

Hi , These might give u an idea I had attached JigsReport.xls which might give u an idea about how I want the report to be generate. Jigs

HI Jibbadiah, ACH_REF field is give name "BOOKINGNO" Jigs

yea ofcourse Sorry, Jigs

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 Thanks EMP and PETER for your support. I had find out the solution from all of the above discussion and suggestions. Jigs :)

Can u pls explain me how to use this converted dates in the original query Please ? Jigs :(

Yes, I did tried with ID#>0 but with this query all the missalaneous formats of dates gets mixed up and doesn't corelate with the desired result I will try with other criteria and check Jigs

OR, You can even try for If number of charecters present in the field name POLNO are same then u can try UPDATE [Renewal MI] SET polno = RIGHT(polno , LEN(polno )-4) Jigs :)