出来るのだＡＳＰ Ｑ＆Ａ掲示板（過去ＬＯＧ） 　訪問数 52046 昨日 889 今日 776
     【PR】 パソコン入門からIT専門書まで幅広く取り揃えています。セブン-イレブン受取り手数料無料のセブンアンドワイ。
Topに戻る 掲示板に戻る 検索 削除 管理者
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]
[5441] SQLでカンマがありませんTO
投稿者：モリコロさん 2005/11/02 13:33:10
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)) & ")"
[5442] SQLでカンマがありませんTO
投稿者：モリコロさん 2005/11/02 13:39:37
> 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)) & ")"
[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)) & ")"
[5444] Re:SQLでカンマがありませんとエラーが出てしまいます。
投稿者：はやしさん 2005/11/02 15:21:32
こんにちは。

> SQL = SQL & CLNG(Trim(ARARI)) & ","
> SQL = SQL & Trim(HATUBAI) & "','"--------------------★
> SQL = SQL & CLNG(Trim(SYURUI)) & ","

これは

ARARI,HATUBAI','SYURUI

となり、カンマではなく'(シングルクォーテーション)の数があっていないのですが、誤植でしょうか？
[5445] Re:SQLでカンマがありませんとエラーが出てしまいます。
投稿者：モリコロさん 2005/11/02 16:55:50
はやしさん早速のご返事ありがとうございます！

早速試してみたところご指摘の通り記述が間違っていたようです。
ですがまた次のエラーが出てしまいました。

◆エラー内容◆
データ型が一致しません。

◆接続情報◆
INSERTしたい内容：05/11/01
INSERTする側のデータ型：DATE

Set CN1 = Server.CreateObject("ADODB.Connection")

CN1.ConnectionString = "DRIVER={Oracle in OraHome81};UID=" & UID & ";PWD=" & PWD & ";DBQ=" & DBName & ";DBA=W;"
CN1.CommandTimeout = 0
CN1.CursorLocation = 3
CN1.Open

以上なんですが、返信をよろしくお願いします。



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

> ◆エラー内容◆
> データ型が一致しません。
>
> ◆接続情報◆
> INSERTしたい内容：05/11/01
> INSERTする側のデータ型：DATE

エラーメッセージそのままではないでしょうか？
DATE型のカラムに対する保存形式を確認してください。
[5447] Re:SQLでカンマがありませんとエラーが出てしまいます。
投稿者：モリコロさん 2005/11/02 17:51:33
ありがとうございます！

オラクル側のデータ型をVARCHAR2に変更して
実行したところ

05/11/01
　　↓
.454545454545454545454545454545454545455

に文字化けして入ってしまいました。

なぜこのようになってしまうのでしょうか。
初歩的な質問で申し訳ありませんが、よろしくお願いします。
[5448] Re:SQLでカンマがありませんとエラーが出てしまいます。
投稿者：はやしさん 2005/11/02 18:15:25
こんにちは。

> 05/11/01
> 　　↓
> .454545454545454545454545454545454545455

５／１１／１＝0.454545454545454545454545454545454545455
ですので、文字化けでもなんでもなく、正しい結果が入っています。


> オラクル側のデータ型をVARCHAR2に変更して
> 実行したところ
素直にDATE型の方が良かったのではないでしょうか？
INSERT文で指定しているのが数値型の形式になっているため出たエラーと思われますので、日付型として INSERTするだけだと思いますが。。
[5449] Re:SQLでカンマがありませんとエラーが出てしまいます。
投稿者：はやしさん 2005/11/02 18:24:31
追記です。

以下のサイトに日付型の INSERT方法などが載ってましたので、参考にどうぞ。

http://www.mitene.or.jp/~rnk/TIPS_ORCL_TBLCREATE.htm

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