>- see footer for list info -<
A while back i wrote about a problem i had with CF sort of caching database
structures and queries and when you add a new column into a table it keeps
reading the old version.
I have also have this error message when that happens as it is writing into the
wrong column or column type or at least it thinks it is.
A CF restart does the trick but if your live server is on shared hosting then
you're buggered. Why this happens I have no idea nor have another solution as
yet.
Jatin Nanda <[EMAIL PROTECTED]> wrote: >- see footer for list info -<
HI Paul, what DB are u using? Also what are the column widths for
tblPropertyDetails?
A truncation error suggests that a field in that table may not be large
enough.
Thx
J
On 12/12/06, Paul Swingewood
wrote:
>
> >- see footer for list info -<
> I have a form submitting some stuff for an estate agents website. I had
> aproblem initially with an IE update which caused teh SSl login to stop
> working. The client hasnow switched to firefox andall seemed well until
> they
> try to upload property details. This system worked fine and I haven't
> changed any code.
>
> When they fill in the form and submit I get an error saying data wouldbe
> truncated .... with this error
>
> INSERT INTO tblPropertyDetails (NoBedroomsIDFK, PropertyTypeIDFK,
> PropertyLocationIDFK, RoadName, Picture, Description1, Description2,
> Description3, Description4, Description5, Description6, PostCode,
> PDFDetails) VALUES ('1', '2', '11', 'test road',
>
> 'C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1621.tmp',
> 'test', 'test', 'test', 'test', 'test', 'test', 'b43 7pq', 'BETT Floor
> Plan.pdf') SELECT @@IDENTITY AS NewID
>
> I have no idea what this is doing here
>
> 'C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1621.tmp'
>
> Can anyone tell me whats going on please ...
>
> Regards - Paul
>
>
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
> -<
>
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
Send instant messages to your online friends http://uk.messenger.yahoo.com
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
