Alternative Nation
Go Back   Alternative Nation > Lounge > Computers & Technology > Web Dev & Programming
Reload this Page How do I stop mysql rounding up?
Register Members List Search Today's Posts Mark Forums Read

Notices
Welcome to the Altnation forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Reply
Page 2 of 2 < 1 2
 
Thread Tools Rate Thread
Old 20th May 2008, 3:24pm   #16
Local Lolcat
 
dalamarthedark's Avatar
 
Join Date: Jun 2004
Location: Tower Of High S
Posts: 3,014
Blog Entries: 16
Images: 19
dalamarthedark = 2nd Bestdalamarthedark = 2nd Bestdalamarthedark = 2nd Best
Send a message via MSN to dalamarthedark Send a message via Skype™ to dalamarthedark
Re: How do I stop mysql rounding up?
Gah, building the SQL up like that is bad form. BAD FORM!

Put in parameters and pass in typed parameters and everything gets formatted correctly (also it is less prone to SQL Injection attacks)

BAD FORM!
__________________
...To begin the New Dawn you can't live for 'her', 'him', 'me' or I', only Us.
dalamarthedark is offline   Reply With Quote
Old 20th May 2008, 5:10pm   #17
(suicidemachine)
 
Largest of Gregs's Avatar
 
Join Date: Jan 2002
Location: Too large
Posts: 17,756
Images: 1021
Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’Largest of Gregs is too good at this 'forum game’
Send a message via MSN to Largest of Gregs Send a message via Skype™ to Largest of Gregs
Re: How do I stop mysql rounding up?
Quote:
Originally Posted by m0nkeymafia View Post
Its not really solved until you have tested it with other cases...
I worded that badly. I meant that I didn't have time to start adding new values,

it works with the 500 of the 40,000 current db values that it was tested on since fixing.

I realise that I probably dont do things the best way and am working on improving

Quote:
Originally Posted by dalamarthedark View Post

BAD FORM!
I need spanked
__________________
Like Siberia, remission is a silent journey across no man’s land, and it’s not always easy to take it alone.'
http://content.altnation.com/gallery.../6/dottsig.jpg
Last edited by Largest of Gregs; 20th May 2008 at 5:10pm. Reason: Automerged Doublepost
Largest of Gregs is offline   Reply With Quote
Old 20th May 2008, 5:15pm   #18
STEVE HOLT!
 
Join Date: May 2001
Location: London
Posts: 5,987
Blog Entries: 1
Zero is a name known to allZero is a name known to allZero is a name known to allZero is a name known to allZero is a name known to allZero is a name known to all
Re: How do I stop mysql rounding up?
Quote:
Originally Posted by dalamarthedark View Post
Gah, building the SQL up like that is bad form. BAD FORM!

Put in parameters and pass in typed parameters and everything gets formatted correctly (also it is less prone to SQL Injection attacks)

BAD FORM!
Unfortunately VBScript doesn't support that. In the past I rolled my own ActiveRecord-style library.
Zero is offline   Reply With Quote
Reply
Page 2 of 2 < 1 2

Bookmarks
Digg del.icio.us StumbleUpon Google

« Quick Javascript/CSS question | Help with website message board »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


AN advertise 



 Classic Grand Advert
Powered by vBadvanced CMPS v3.0.0
Advertisement
   



All times are GMT +0. The time now is 4:55am.

Advertising - Link To Us - Staff - Submit News - Sponsor AN - Site Rules
Contact Us - Alternative Nation - Archive - Top
Forums Directory
Copyright 2000-2008, Alternative Nation

SEO by vBSEO 3.1.0 ©2007, Crawlability, Inc.
Page generated in 0.42030 seconds with 15 queries