User Profile

Collapse

Profile Sidebar

Collapse
adelemb
adelemb
Last Activity: Aug 26 '08, 01:23 PM
Joined: Feb 13 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • adelemb
    replied to simple SQL ELSE IF statement help
    in Oracle
    Hi,
    we are using an anonymous plsql block so the ROWCOUNT sounds like it could be what I need.
    Ill look into it further, thanks to you both for the suggestion. :-)
    See more | Go to post

      Leave a comment:

    • adelemb
      started a topic simple SQL ELSE IF statement help
      in Oracle

      simple SQL ELSE IF statement help

      Hi all,

      We have an Oracle database and my problem is with SQL, apologies if this is posted in the wrong forum.
      I have this SQL statement that all works fine:

      Code:
      var newConn = new openConnection(); 
if(request.searchBox) 
{ 	
var searchBox = request.searchBox; 	
var keywords = searchBox.split(' ') 	 	
var sql = 'SELECT forumID, masterID, subject, message, datePosted FROM THREADS
      ...
      See more | Go to post
      • adelemb
        started a topic SQL Select statement as a keyword search
        in Oracle

        SQL Select statement as a keyword search

        Hi,

        I'm trying to make a SQL statement work and am getting quite mixed up with it, I hope someone can help!

        I have a form with a textbox named "keyword". I want the user to enter a keyword and then a search occurs through the table to find that keyword. The results should then be displayed on the next page. I have the keyword parameter appearing in the page URL e.g. www.xxxxxx.com/page.htm?keywor d=help
        ...
        See more | Go to post
        • adelemb
          replied to Replace function in URL, ignoring first instance of character
          in Javascript
          Hi, thanks for this suggestion, Ill look into it (Google it) today :)...
          See more | Go to post

            Leave a comment:

          • adelemb
            started a topic Replace function in URL, ignoring first instance of character
            in Javascript

            Replace function in URL, ignoring first instance of character

            Hi,

            I have a bit of JavaScript for a Tell a Friend link. The person enters an email into a box clicks submit and their email programme opens a new mail with the URL from the referring page. My problem is that while some bits of the URL need replacing to make it work, others need to be left as they are.

            The title for the pages are in the URL e.g. this page has the title "IDIOTS OR WHAT?!"
            http://www...../mim_forums_home page-user/mim_forums_thre ad.htm?masterID =195&forumID=28 1&startPos=0&ti tle=<b>IDIOTS%2 0OR%20WHAT?!</b>...
            See more | Go to post
            • adelemb
              started a topic Display image if time elapsed is less than 24hours
              in Javascript

              Display image if time elapsed is less than 24hours

              Hi all,

              I want an image to display in a table if another table cell shows an updated date of less than 24hours. The date displayed in the cell is already working and display fine, but I have no idea where to start with calling the image!

              This is to be used on a forum that displays a list of posted messages in a table. If a new message is posted under a topic, then I want an image to display for that topic indicating...
              See more | Go to post
              No activity results to display
              Show More
              Working...