Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: manj
  • Order by date
  1. manj

    Change the SQL ORDER BY ASC OR DESC clause via a form button

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

    ClusterCats - URL problem

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

    Dynamically creating static HTML pages

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

    Submitting a dynamic website to search engines

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

    group by problem?

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

    Forms / Two submit buttons

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

    drop-down boxes that go up?

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

    Trigger help

    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?
  9. manj

    Trigger help

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

    SQL problem

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

    INTERSHOP

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

    Are there any functions, syntax etc

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

    Are there any functions, syntax etc

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

    Creating a table

    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) ) /
  15. manj

    Creating a table

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

    Dynamic layer

    Hi GunJack, Thanks for the DHTML code - it works. Hopefully I can adapt this to my code. Cheers again.
  17. manj

    Dynamic layer

    Has anybody been able to create a dynamically populated layer. The effect I'm trying to create is to have a drop-down feature which has dynamic content but within a layer. I'm more concerned with it working in IE than NN. Any help will be greatly appreciated.
  18. manj

    Sample ColdFusion sites

    Hi, Try the following sites: www.toysrus.co.uk www.isis-publishing.co.uk www.panozmotorsports.com www.commercenti.com All have been developed by Commerce NTI
  19. manj

    Image repeat problem on my pages!?!

    You could try style=&quot;background-repeat: &quot; attribute. Have a go.
  20. manj

    Drop-down list

    Thanks onirike - it worked.

Part and Inventory Search

Back
Top