tagCANDY CGI VBレスキュー(花ちゃん) の Visual Basic 2010 用 掲示板(VB.NET 掲示板)
VBレスキュー(花ちゃん) の Visual Basic 2010 用 掲示板(VB.NET 掲示板)
[ツリー表示へ]  [ワード検索]  [Home]

タイトル Re^10: バイナリデータが切り捨てられます。no
投稿日: 2007/08/27(Mon) 14:43
投稿者
>                 Sql = ""
>                 Sql &= "UPDATE"
>                 Sql &= " " & "個人情報"
>                 Sql &= " " & "SET"
>                 Sql &= " " & "ID " & "= "
>                 Sql &= "'" & idNo & "'" & ","
>                 Sql &= " " & "姓 " & "= "
>                 Sql &= "'" & sei & "'" & ","
>                 Sql &= " " & "名 " & "= "
>                 Sql &= "'" & mei & "'" & ","
>                 Sql &= " " & "性別 " & "= "
>                 Sql &= "'" & seibetu & "'" & ","
>                 Sql &= " " & "生年月日元号 " & "= "
>                 Sql &= "'" & seinengen & "'" & ","
>                 Sql &= " " & "生年月日年 " & "= "
>                 Sql &= "'" & seinennen & "'" & ","
>                 Sql &= " " & "生年月日西暦 " & "= "
>                 Sql &= "'" & seireki & "'" & ","
>                 Sql &= " " & "生年月日月 " & "= "
>                 Sql &= "'" & seinentuki & "'" & ","
>                 Sql &= " " & "生年月日日 " & "= "
>                 Sql &= " " & seinenhi & "'" & ","
>                 Sql &= " " & "郵便1 " & "= "
>                 Sql &= "'" & yubin1 & "'" & ","
>                 Sql &= " " & "郵便2 " & "= "
>                 Sql &= "'" & yubin2 & "'" & ","
>                 Sql &= " " & "住所1 " & "= "
>                 Sql &= "'" & jusho1 & "'" & ","
>                 Sql &= " " & "住所2 " & "= "
>                 Sql &= "'" & jusho2 & "'" & ","
>                 Sql &= " " & "方書 " & "= "
>                 Sql &= "'" & kata & "'" & ","
>                 Sql &= " " & "TEL " & "= "
>                 Sql &= "'" & tele & "'" & ","
>                 Sql &= " " & "携帯電話 " & "= "
>                 Sql &= "'" & keitai & "'" & ","
>                 Sql &= " " & "FAX " & "= "
>                 Sql &= "'" & faxNO & "'" & ","
>                 Sql &= " " & "Mailadress " & "= "
>                 Sql &= " " & mail & "'"
>                 Sql &= " " & "WHERE " & "("
>                 Sql &= " " & "ID"
>                 Sql &= " " & "="
>                 Sql &= "'" & Mid(CStr(Code), 1, 3) & "' " & ")"   '3,1

よく確認してください。
「'」が足りてない部分がありますよ。

- 関連一覧ツリー をクリックするとツリー全体を一括表示します)

古いスレッドにレスはつけられません。