1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

strange problem with mssql and ASP

Discussion in 'C#' started by gworld, Oct 11, 2005.

  1. #1
    I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.

    I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.

    I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
    The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.

    I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.

    Any idea what can cause such strange problem? :confused:

    Here is dump of some rows from database:
    SEMrush
    LinkID,LinkTitle,LinkURL,LinkDescription,CategoryID
    8601,Restorable Iron, Albuquerque. NM.,http://www.restorableiron.com/,Restorable cars and trucks for for car enthusiast in the Southwest.,38
    8602,used cars for sale,http://www.thevirtualgarage.co.uk,search used cars for sale in uk,sell your car for free advertise untill sold,insurance,loans,warranty and more,734
    8603,Ford Forum,http://www.fordforum.com,Ford discussion forum for Ford owners and enthusiasts,260
    8605,Classic Car Fair,http://www.classiccarfair.com/,New Zealand's best selection of classic vehicles,38
    8606,FinnShark - the Finnish Corvette Portal,http://finnshark.com/,Even in this cold and remote Northern country, the legendary all-American sports car roams the streets.,38
    8610,Accel Warranty - Auto Warranty, extended car warranties, extended auto warranties, auto warranties,http://www.accelwarranty.com,Build your custom extended auto warranty for new and used vehicles.,744
    8611,Acura Extended Warranty Apply Online for a Factory Backed Acura Warranty,http://www.curryacuracare.com,Acura Care the only Acura extended warranty that is factory backed. Acura warranty provides affordable and comprehensive extended warranty coverage for your new Acura vehicles.,744
    8612,An extended auto warranty $100s below dealer prices Auto Service Warranty, Inc.,http://www.Autoservicewarranty.com,Want an extended auto warranty below dealer prices? Buy Car Warranties Direct with NO Middleman and Save $100s.,744
    8613,Auto Warranty - e-Warranty Solutions -Extended Auto Warranty,http://e-warrantysolutions.com,auto warranty - e-warranty solutions - a premier online provider of extended warranties offering free extended auto warranty quotes for new and used vehicles,744
    8614,Auto Warranty Associates Extended Auto Warranty Coverage,http://www.autowarrantyassociates.com/,Auto Warranty Associates offering A Rated Direct Insured extended auto warranty programs for domestic and import vehicles at affordable prices.,744


    LinkID8601-06 are the old one and 8610-8614 are new one, there is no problem working with this in enterprise manager, it is only in asp script including error message that LinkID field does not exist.
     
    gworld, Oct 11, 2005 IP
    SEMrush
  2. JamieC

    JamieC Well-Known Member

    Messages:
    226
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    138
    #2
    OK, few things:

    1. Do you have a URL of this script that's live on the Internet?

    2. Are you saying that you can copy the URL printed by the database, but when you click on the exact same url, you get a 404?

    3. This sounds to me like you're not escaping some characters correctly. Check the outputted HTML code for stray 's and "s.

    4. Try to come back with more detail!

    Good luck,

    Jamie
     
    JamieC, Oct 19, 2005 IP