[ツリー表示へ] [ワード検索] [Home]
タイトル ： Re^11: バイナリデータが切り捨てられます。no 投稿日 ： 2007/08/27(Mon) 14:58 投稿者 ： kokoro
| > > 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 > > よく確認してください。 > 「'」が足りてない部分がありますよ。 seinenhiとmailですね？ご指摘ありがとうございます。修正しましたが、まだ結果は同じです。 |
をクリックするとツリー全体を一括表示します） - バイナリデータが切り捨てられますで登録失敗します。 - kokoro 07/08/27-11:59No.6152