Welcome to the Reef Forum.
+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Contributing Member

    Join Date
    Mar 2004
    Location
    MI USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Livestock [FIXED]

    Trying to add Corals to the system, and can only add one.

    Once I have one in, I can pick the option to add the second one, but after entering all the details and submitting, I still only see one in the list.

    Steve

  2. #2
    Moderator
    Join Date
    Feb 2000
    Location
    Bardstown, KY
    Posts
    13,760
    Images
    51
    Thanks
    0
    Thanked 1 Time in 1 Post
    Steve,

    Aftering adding the second one and being redirected, were you redirected to the coral you just tried to add? If so, were there any errors displayed on that page? If not, where did it redirect you to?

    Try to add another now and see what you get.

    Thanks,
    Scott Z.

  3. #3
    Contributing Member

    Join Date
    Mar 2004
    Location
    MI USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool

    Quote Originally Posted by Reefland
    Steve,

    Aftering adding the second one and being redirected, were you redirected to the coral you just tried to add? If so, were there any errors displayed on that page? If not, where did it redirect you to?

    Try to add another now and see what you get.

    Thanks,
    Scott Z.
    No errors shown, but I tracked down the problem. I bought the second coral from Kee's Pets. Putting the ' in the name confused the system (i'm guessing you use ' as a delimiter in your insert line for the DB). Removing the apostrophe (and using Kees Pets instead) resulted in the acceptance of the livestock entry with no problem.

    Perhaps a quick bit of Javascript to remove ' from the input, or some method to escape them so they get entered properly in the database ?

    Steve

  4. #4
    Moderator
    Join Date
    Feb 2000
    Location
    Bardstown, KY
    Posts
    13,760
    Images
    51
    Thanks
    0
    Thanked 1 Time in 1 Post
    Yeah I think I am going to have to run each data entry field through a more complex strip function as this is the same problem Mike had with the cost of an item. I have already started working up the function to strip all of these characters, just need to get it in place.
    Scott Z.
    75 Gallon Reef Log
    Powered by Reefland's Personal Online Aquarium Log

  5. #5
    Moderator
    Join Date
    Feb 2000
    Location
    Bardstown, KY
    Posts
    13,760
    Images
    51
    Thanks
    0
    Thanked 1 Time in 1 Post
    Alright, this is now resolved. Please test it and let me know if there are any additional problems.

    Scott Z.

  6. #6
    Contributing Member

    Join Date
    Mar 2004
    Location
    MI USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Reefland
    Alright, this is now resolved. Please test it and let me know if there are any additional problems.

    Scott Z.
    Ok, I tested with the following inputs :

    Common Name : Prayer Coral
    Scientific Name : Deitus Beseechum
    Bought From : Kee's Pets
    Price : $39.99

    Went in just fine, and shows correctly in the summary (minus the ' and the $ as expected).

    Steve

  7. #7
    Moderator
    Join Date
    Feb 2000
    Location
    Bardstown, KY
    Posts
    13,760
    Images
    51
    Thanks
    0
    Thanked 1 Time in 1 Post
    Good deal. At first your post worried me though because I do not want the ' to be stripped, and when I read your post I thought it was being removed. I looked at your entry though and see that it does contain the ' and entered the db just fine.
    Scott Z.
    75 Gallon Reef Log
    Powered by Reefland's Personal Online Aquarium Log


 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Thinking of adding lights.
    By Pomme in forum Reef Aquariums
    Replies: 8
    Last Post: 04-22-2004, 04:12 PM
  2. near philadelphia- livestock, then drygoods for sale
    By BEERBARON in forum For Sale or Trade Zone
    Replies: 2
    Last Post: 11-03-2003, 09:18 AM
  3. adding a few "squids " to my set-up
    By organicreefer in forum Tanks, Filtration & Basic Equipment
    Replies: 5
    Last Post: 02-19-2003, 03:01 PM
  4. Replies: 15
    Last Post: 09-18-2001, 11:08 AM
  5. peppermint shrimp vs. other livestock
    By gramma royale in forum Reef Aquariums
    Replies: 3
    Last Post: 07-23-2001, 10:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107