Recent content by manj

This it possible using a form button to change the ORDER BY clause sequence from ascending to descending of a particular table column. Pressing the button again will do the reverse. I have managed to order by a particular column but not reverse the order. SQL STATEMENT... <CFIF...

Hi, I have ClusterCats query. I have a website for example www.mydomain.com. When I enter the URL I get www1.mydomain.com or www2.mydomain.com appearring within the browser address box. I wish www.mydomain.com to only appear at all times within the address box. Can anybody help? Cheers

Hi, I understand that using cfschedule coldfusion has the ability to create static pages. But how exactly do i do this. I have data within a database which i want to extract and display this into a static HTML file. Any ideas or hints will be appreciated.

Hi, This is a general question to developers. We have developed a website in coldfusion and spectra. Considering that search engines send out spiders or web-crawlers to index the web. How do they index a dynamic or data-driven website where there is no hardcoding. Any help or advice would be...

I have a table on sql server with the following data: 2 columns 1 mug 1 glass 2 book 2 pad... Is it possible to construct a query to create the following: 1 mug, glass 2 book, pad 3 ... etc

<SCRIPT> function submitFunction(i) { if (i==1) document.theForm.action= &quot;http://www.company.com/cgi-bin/cgi1.cgi&quot;; if (i==2) document.theForm.action= &quot;http://www.company.com/cgi-bin/cgi2.cgi&quot;; if (i==3) document.theForm.action=...

Hi, is it possible with scripting or css to enable a drop-down box to become a drop-up box. Hence the options are displayed upwards instead of downwards. Cheers

Cheers Mike, In the 'code here' section how can I reference the row that has just been inserted, and hence insert the additional columns on that specific row?

Can anybody tell me how to create a trigger in Oracle. This is the scenario. Insert a row into table A, all but two columns are inserted. The other remaining columns are then inserted via a trigger on the same row.

If your tables are exactly the same you could try: insert into table A select * from table B;

Has anybody out there used the INTERSHOP product. If you have can you tell me the pros and cons of using the product, or direct me any user/discussion groups. Thanks.

The end-user is prompted to enter a value. What I need to do is to check that they have entered the correct data. Hence check that it is either a date, number etc and give a warning message to the end-user if they enter incorrect data.

Are there any functions, syntax etc within pl/sql where I can check if a variable is numeric or a date type etc. For example: IF variable IS NUMERIC do something ELSIF variable IS DATE do something ELSE do something Cheers

The thing is that I have created a primary key as follows: CREATE TABLE AGGR_Billing_Item ( ORDER_ID NUMBER, ORDER_ITEM_ID NUMBER, ... PRIMARY KEY ORDER_ID, ORDER_ITEM_ID) ) /

Hi, New to Oracle. Currently trying to create a table with Foreign keys but it comes up with an error: ORDER_ID NUMBER REFERENCES AGGR_BILLING_ITEM (ORDER_ID) ERROR at line 4: ORA-02270: no matching unique or primary key...