タイトル : 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 よく確認してください。 「'」が足りてない部分がありますよ。 |