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 TouchToneTommy 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
  • Content: Threads
  • 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

    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
  7. 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.
  8. 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.
  9. 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
  10. 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...
  11. 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.
  12. manj

    Drop-down list

    I have a drop-down box with various options. The question is how do I direct the user to the desired page when they select a particular option. I have copied some of the code below but it doesn't work. Any help please. SCRIPT LANGUAGE=&quot;JavaScript&quot;> <!-- JavaScript begins... function...
  13. manj

    Select drop-down list

    I have a drop-down box with various options. The question is how do I dirct the user to the desired page when they select a particular option. Is it something to do with the onChange or onFocus event handler? Any help appreciated. Cheers
  14. manj

    Event Handlers : onMouseOut, onMouseOver

    I have the following code: <td onmouseout=&quot;bgColor=''&quot; onmouseover=&quot;bgColor='#ccffcc'&quot;><A HREF=&quot;test.htm&quot;>Cups & Mugs</A></td> This works fine in IE but not in Netscape. Are these attributes supported by NN. If not is there a work-a-round solution. Any help...
  15. manj

    Disjointed rollovers images with text

    I have a series of text hyperlinks which all have an associated image. Upon rolling over the text links I wish the associated image to appear. All images will appear in the same area. Can anybody help? Cheers
  16. manj

    Nested CFOUTPUT

    How do I go about solving this type of problem: <cfoutput query1> returns many roles </cfoutput> <cfoutput> return a single value <cfoutput> <cfoutput query1> continue displaying initial query1 results </cfoutput>
  17. manj

    Determine the existence of a primary key

    How can I determine the existence of a primary key on table X before I create a link between tables X and Y. Any help will be appreciated. Cheers
  18. manj

    Find records between two dates

    I have a query. I wish to select records that are between the current date and 1 month prior to the current date. How do I achieve this? select col1, col2 from table where date between currentdate and 1 month before current date Any help will be appreciated.

Part and Inventory Search

Back
Top