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.

Help with MC ACESS insert please

Discussion in 'Programming' started by danjapro, Feb 26, 2009.

0
  1. #1
    Help with this Statement it works in SQL but not for ACCESS:

    sql = "insert into PLAN.[plan] (name, price, PLAN.[desc], feature_post_profile, feature_view_profile, feature_upload_photo, feature_upload_video, feature_upload_audio, feature_quick_search, feature_detailed_search, feature_save_search, feature_add_favorites, feature_send_messages, feature_receive_messages, feature_chat, feature_more_photo, paypal, length) values ('" & name & "', " & price & ", '" & desc & "', 0" & feature_post_profile & ", 0" & feature_view_profile & ", 0" & feature_upload_photo & ", 0" & feature_upload_video & ", 0" & feature_upload_audio & ", 0" & feature_quick_search & ", 0" & feature_detailed_search & ", 0" & feature_save_search & ", 0" & feature_add_favorites & ", 0" & feature_send_messages & ", 0" & feature_receive_messages & ", 0" & feature_chat & ", 0" & feature_more_photo & ", '" & paypal & "', 0" & length & ")"
    Code (markup):

     
    danjapro, Feb 26, 2009 IP