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 dencom 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: *

  1. thewhistler1

    window.event is undefined

    Hello all I have an issue getting this to work in firefox, it seems to work fine in other browsers but firefox gives an error window.event is undefined when I try to use this. Any ideas? <script> document.onkeydown=function(evt) { var thelink if (window.event.keyCode==37)...
  2. thewhistler1

    Javascript onkeydown event to go to next page

    On my website I use paging so that all the results don't hit the page all at once. Then of coarse I have links to take you to the next set of results. What I would like to do is make the right and left arrow buttons on the keyboard work to go forward and backward to other pages of results. I use...
  3. thewhistler1

    using a variable in a google map script

    I am trying to get a google map on my site but I cant figure part of it out. I know very little about javascript, Im sure this is a simple fix. The code below starts with one map and has a box to go to another location. What I would like is for the page to come up to whatever address that I have...
  4. thewhistler1

    How to stop PHP from rotating my images when resizing?

    I am creating a website that allows uploading of images. The images are resized to certain specs, then placed into a folder. One problem I have is when I upload and resize a photo that is taller than it is wide the photo actually rotates 90 degrees. I am using imagecopyresampled to resize the...
  5. thewhistler1

    php upload &amp; resize not inserting the correct thing in DB

    Hello Im trying to upload and resize an image and insert it into a MySQL database, but I am doing something wrong. It inserts a record but it is very small and not the image at all. When I check the error log is shows this: PHP Warning: imagecopyresized(): supplied argument is not a valid...
  6. thewhistler1

    PHP - Display a unix calendar

    I am trying to display a calendar on my web page, just the current month. I think the easiest way to do this would be to just display a unix calendar with the cal command. I did this $cal = `cal`; $cal = nl2br($cal); echo $cal; but the numbers don't line up correctly. Any one know how to...
  7. thewhistler1

    PHP

    Does anyone know how to use strtotime to give me a variable date + 1 year? I know how to do it using todays date like this: $newdate = date("Y-m-d",strtotime('+1 year')); echo $newdate ; but I want to use a date that was entered in a form instead of todays date. I tried the following but it...
  8. thewhistler1

    How to pull up a list of user added functions

    Hello I am trying to bring up a list of user added functions. I know that \df is supposed to bring up functions but I don't see the ones I added, even if I do a \df *. Any ideas on how I could do this.
  9. thewhistler1

    How to make extract month or day a two digit number.

    I'm trying to produce an order number out of parts of the date. I tried this: select extract(month from now()); and I get: 2 then I did this: select extract('month' from now())|| extract('day' from now()); and...
  10. thewhistler1

    Is is posible to search the database for column names

    I work with a data base that has about 400 tables and sometimes it is hard figuring out how tables relate to other tables. What I would like to do if possible is write a script that searches the column names. example Table name - team_member Columns - team_member_oid, name,address,phone...
  11. thewhistler1

    How can I remove leading spaces from a table?

    I recently imported a large amount of contact info into my database and now the last_name column has a space before the name and some of them have several spaces after the name? Is it possible to remove these spaces with an update command, a function or with trim? Thanks
  12. thewhistler1

    Trying to write a function

    I have a table called "movie" and I would like to bring up the last X number of them with this function but it gives me error: ERROR: return type mismatch in function declared to return text DETAIL: Final SELECT must return exactly one column. CONTEXT: SQL function "last_movie" here is...

Part and Inventory Search

Back
Top