出来るのだＡＳＰＱ＆Ａ掲示板（過去ＬＯＧ）

出来るのだＡＳＰＱ＆Ａ掲示板（過去ＬＯＧ） 　訪問数 52046 昨日 889 今日 776
【PR】パソコン入門からIT専門書まで幅広く取り揃えています。セブン-イレブン受取り手数料無料のセブンアンドワイ。

Topに戻る

掲示板に戻る

検索

削除

管理者

[5443] SQLでカンマがありませんとエラーが出てしまいます。

コメントする

投稿者：モリコロさん 2005/11/02 13:48:56

初めての投稿で入力している最中に投稿されてしまい、何度も変なレスを申し訳ありません。

早速質問なのですが、ASPで下記SQLを入力してデータベースに書き込みたいのですが、★マークのところで【カンマがありません】とエラーになってしまします。
１つづつコメントにしてどこでエラーになるのか試してみたところ★のところだと言うことが分かりました。
SQLもASPも初心者なもので、単純な構文ミスだと思うのですが
かれこれ3日間ぐらいこのエラーがつぶせづに止まってしまっている状態です。

質問の文章もこれだけでよいのかわかりませんがどなたか返信をお願いします。

よろしくお願いします。
Sub INSERT_QUERY
SQL = "INSERT INTO 商品ワーク("
SQL = SQL & "商品コード,"
SQL = SQL & "正式品名,"
SQL = SQL & "正式規格,"
SQL = SQL & "正式品名カナ,"
SQL = SQL & "正式規格カナ,"
SQL = SQL & "短縮品名,"
SQL = SQL & "短縮規格,"
SQL = SQL & "短縮品名カナ,"
SQL = SQL & "短縮規格カナ,"
SQL = SQL & "ブランド名,"

SQL = SQL & "仕入先コード,"
SQL = SQL & "JANコード,"
SQL = SQL & "ボールITF,"
SQL = SQL & "ケースITF,"

SQL = SQL & "ボール入数,"
SQL = SQL & "ケース入数,"
SQL = SQL & "発注単位,"
SQL = SQL & "単品幅,"
SQL = SQL & "単品奥,"
SQL = SQL & "単品高さ,"
SQL = SQL & "ボール幅,"
SQL = SQL & "ボール奥,"
SQL = SQL & "ボール高さ,"
SQL = SQL & "ケース幅,"
SQL = SQL & "ケース奥,"
SQL = SQL & "ケース高さ,"

SQL = SQL & "旧仕入単価,"
SQL = SQL & "旧二次卸単価,"
SQL = SQL & "旧標準卸単価,"
SQL = SQL & "旧標準小売単価,"

SQL = SQL & "新仕入単価,"
SQL = SQL & "新二次卸単価,"
SQL = SQL & "新標準卸単価,"
SQL = SQL & "新標準小売単価,"
SQL = SQL & "展示会価格,"
SQL = SQL & "粗利率,"

SQL = SQL & "発売日,"---------------------★

SQL = SQL & "種類,"

SQL = SQL & "種別,"
SQL = SQL & "内容,"
SQL = SQL & "形状,"
SQL = SQL & "対象,"
SQL = SQL & "用途,"
SQL = SQL & "細分,"
SQL = SQL & "JICFS,"

SQL = SQL & "材質,"
SQL = SQL & "色,"
SQL = SQL & "電源,"
SQL = SQL & "内容量,"
SQL = SQL & "単品重量,"
SQL = SQL & "ボール重量,"
SQL = SQL & "ケース重量,"

SQL = SQL & "商品説明,"
SQL = SQL & "キャッチコピー01,"
SQL = SQL & "キャッチコピー02,"

SQL = SQL & "消費電力,"
SQL = SQL & "付属品,"
SQL = SQL & "製造,"
SQL = SQL & "輸入区分,"

SQL = SQL & "インストア区分,"
SQL = SQL & "手打ち区分,"
SQL = SQL & "処理区分,"
SQL = SQL & "PB区分,"
SQL = SQL & "廃番区分,"
SQL = SQL & "展示会集計区分,"
SQL = SQL & "更新日,"
SQL = SQL & "登録日,"
SQL = SQL & "オフコン品種)"

SQL = SQL & " VALUES("
SQL = SQL & CLNG(Trim(SYOHIN_CD)) & ",'"
SQL = SQL & Trim(SEI_HIN) & "','"
SQL = SQL & Trim(SEI_KIKAKU) & "','"
SQL = SQL & Trim(SEI_HIN_KANA) & "','"
SQL = SQL & Trim(SEI_KIKAKU_KANA) & "','"
SQL = SQL & Trim(TAN_HIN) & "','"
SQL = SQL & Trim(TAN_KIKAKU) & "','"
SQL = SQL & Trim(TAN_HIN_KANA) & "','"
SQL = SQL & Trim(TAN_KIKAKU_KANA) & "','"
SQL = SQL & Trim(BRAND) & "',"

SQL = SQL & CLNG(Trim(SIIRE_CD)) & ",'"
SQL = SQL & Trim(JAN) & "','"
SQL = SQL & Trim(BOWL_ITF) & "','"
SQL = SQL & Trim(CASE_ITF) & "',"

SQL = SQL & CLNG(Trim(BOWL_IRISU)) & ","
SQL = SQL & CLNG(Trim(CASE_IRISU)) & ","
SQL = SQL & CLNG(Trim(HACHU_TANI)) & ","
SQL = SQL & CLNG(Trim(TAN_HABA)) & ","
SQL = SQL & CLNG(Trim(TAN_OKU)) & ","
SQL = SQL & CLNG(Trim(TAN_TAKASA)) & ","
SQL = SQL & CLNG(Trim(BOWL_HABA)) & ","
SQL = SQL & CLNG(Trim(BOWL_OKU)) & ","
SQL = SQL & CLNG(Trim(BOWL_TAKASA)) & ","
SQL = SQL & CLNG(Trim(CASE_HABA)) & ","
SQL = SQL & CLNG(Trim(CASE_OKU)) & ","
SQL = SQL & CLNG(Trim(CASE_TAKASA)) & ","

SQL = SQL & CLNG(Trim(OLD_SIIRE_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_NIJI_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_ORO_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_KOURI_TAN)) & ","

SQL = SQL & CLNG(Trim(NEW_SIIRE_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_NIJI_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_ORO_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_KOURI_TAN)) & ","
SQL = SQL & CLNG(Trim(TENJI_GAKU)) & ","
SQL = SQL & CLNG(Trim(ARARI)) & ","

SQL = SQL & Trim(HATUBAI) & "','"--------------------★

SQL = SQL & CLNG(Trim(SYURUI)) & ","

SQL = SQL & CLNG(Trim(SYUBETU)) & ","
SQL = SQL & CLNG(Trim(NAIYO)) & ","
SQL = SQL & CLNG(Trim(KEIJO)) & ","
SQL = SQL & CLNG(Trim(TAISHO)) & ","
SQL = SQL & CLNG(Trim(YOUTO)) & ","
SQL = SQL & CLNG(Trim(SAIBUN)) & ","
SQL = SQL & CLNG(Trim(JICFS)) & ",'"

SQL = SQL & Trim(ZAISITU) & "','"
SQL = SQL & Trim(COLOR) & "','"
SQL = SQL & Trim(DENGEN) & "',"
SQL = SQL & CLNG(Trim(NAIYORYO)) & ","

SQL = SQL & CLNG(Trim(TAN_JURYO)) & ","
SQL = SQL & CLNG(Trim(BOWL_JURYO)) & ","
SQL = SQL & CLNG(Trim(CASE_JURYO)) & ",'"

SQL = SQL & Trim(SETUMEI) & "','"
SQL = SQL & Trim(C_COPY01) & "','"
SQL = SQL & Trim(C_COPY02) & "',"

SQL = SQL & CLNG(Trim(DENRYOKU)) & ",'"
SQL = SQL & Trim(FUZOKU) & "',"
SQL = SQL & CLNG(Trim(SEIZO)) & ","
SQL = SQL & CLNG(Trim(YUNYU)) & ","

SQL = SQL & CLNG(Trim(INSTORE)) & ","
SQL = SQL & CLNG(Trim(TEUCHI)) & ","
SQL = SQL & CLNG(Trim(SYORI)) & ","
SQL = SQL & CLNG(Trim(PB)) & ","
SQL = SQL & CLNG(Trim(HAIBAN)) & ","
SQL = SQL & CLNG(Trim(TENJI_SYUKEI)) & ",'"
SQL = SQL & Trim(KOUSIN) & "','"
SQL = SQL & Trim(TOROKU) & "',"
SQL = SQL & CLNG(Trim(OP_HINSHU)) & ")"

削除する

SQLでカンマがありませんTO 　モリコロさん [2005/11/02 13:33:10] [5441]

SQLでカンマがありませんTO 　モリコロさん [2005/11/02 13:39:37] [5442]
　

SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 13:48:56] [5443]
　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 15:21:32] [5444]
　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 16:55:50] [5445]
　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 17:07:08] [5446]
　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 17:51:33] [5447]
　　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 18:15:25] [5448]
　　　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 18:24:31] [5449]

TreeBBS For ASP V.0.1.3
Program By ＹａｓＮｅｔ