asp.net - String or binary data would be truncated. The statement has been terminated - 


protected sub cmdok_click(byval sender object, byval e system.eventargs) handles cmdok.click         dim medid, medname, comment string         dim power, period, qtty integer         'dim nextdateofdelivery date = getnextdateofdelivery(val(txtdays.text))         dim today system.datetime         dim answer system.datetime         today = system.datetime.now         answer = today.adddays(val(txtdays.text))         dim nextdateofdelivery date = answer           medname = trim(txtmedname.text)         qtty = val(txtquantity.text)         comment = txtcomment.text         power = txtpower.text         medid = lblmedid.text         period = val(txtdays.text)         '............setting priorities         '.......value of p(0) indicates priority tablest , on forth.....         dim p() integer = {0, 0, 0, 0}         = 0 lbpriorities.items.count - 1             select case lbpriorities.items(i).text                 case "tablet"                     p(0) = + 1                 case "capsule"                     p(1) = + 1                 case "liquid"                     p(2) = + 1                 case "injection"                     p(3) = + 1              end select          next          '............if not available         dim strictlythis string = radnotavailable.selecteditem.value         dim connstr string = configurationmanager.connectionstrings("databaseconnectionstring").connectionstring          dim con new sqlclient.sqlconnection(connstr)         'dim con new sqlclient.sqlconnection("data source=.\sqlexpress;" & _         '                                       "attachdbfilename=|datadirectory|\database.mdf;" & _         '                                       "integrated security=true;user instance=true")          dim sql new sqlclient.sqlcommand("insert medicine" & _             "(medid, userid, medname, quantity, dateoforder, power, tabpriority, cappriority, liqpriority, " & _             "injpriority, period, notavailable, prescription, comment, nextdateofdelivery)" & _             "values('" & medid & "','" & user.identity.name & "','" & medname & "'," & qtty & ",'" & today & "'," & power & _             "," & p(0) & "," & p(1) & "," & p(2) & "," & p(3) & ",'" & period & "','" & strictlythis & "', '' ,'" & comment & "','" & nextdateofdelivery & "')", con)          con.open()         sql.executenonquery()         con.close()         con.dispose()          lblmessage.text = "the details of medicine have been saved. may upload prescription"         fuprescription.enabled = true         cmdupload.enabled = true     end sub

this using now...but error saying "string or binary data truncated. statement has been terminated." mean???is there wrong sql statement???

i'd value you're storing in dateoforder.

according screenshot, varchar(10), you're storing datetime.now.tostring() in there, default value of of format:

5/1/2008 6:32:06 pm

which comes in @ 19 characters.

i suggest store dates , times in more suitable field, such date or datetime field.

if must store text, should @ least store in format suitable sorting, , unambiguous, such as:

datetime.now.tostring("o") // round-trip format

which give you:

2008-06-15t21:15:07.0000000

Comments

Post a Comment

Popular posts from this blog

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

java - Output of Eclipse is rubbish -

i want write program in eclipse language different english. when display output using system.out program, displays output correctly in console editor. when accept input console , output it, output rubbish. how can solve it. many thnaks i'm not sure if problem, have character encoding problem. make sure you're using unicode, utf-8. you can read more @ official docs converting non-unicode text .
Read more

jquery - Confused with JSON data and normal data in Django ajax request -

i read json internet still have not got grasp of it. reading article http://webcloud.se/log/ajax-in-django-with-jquery/ i not understood first part function using json def xhr_test(request, format): if request.is_ajax(): if format == 'xml': mimetype = 'application/xml' if format == 'json': mimetype = 'application/javascript' data = serializers.serialize(format, examplemodel.objects.all()) return httpresponse(data,mimetype) # if want prevent non xhr calls else: return httpresponse(status=400) my main problems are from function getting format variable does format json mean data given function json or data recived json can give me simple example ouput of function data = serializers.serialize(format, examplemodel.objects.all()) how use data when response in jquery function if don't use json in above function how input , response chnage thanks ...
Read more