Int fields... - MySQL Database

Dave

Hi,

I am using ASP, connecting to MySQL.

I have an issue, that appeared to be working OK, but having just read my web
logs, have found a problem.

I am using MySQLFront to connect to my ISPs MySQL Server.

I have created a table, with a defined int field, 11 wide (e.g. MyField
Int(11) )

Now, I am inserting a number that is 10 wide into it. However, just lately,
I am getting...

Microsoft Cursor Engine '80040e21'

Multiple-step operation generated errors. Check each status value.
Two typical numbers I am inserting...
8340801334
5731311330

In order to get around the problem, I have made the field a varchar(11) but
would prefer to go back to int(11).

Thanks for your help.

Best regards.
Dave.
--
~~
All I ask is a chance to prove that money can't make me happy.

Your community connected. http://www.ashfieldfocus.com
Get your business on the net, http://www.clickprovince.com
Collectible dolls from http://www.collectorsdolls.com
Web design, hosting, domain registration? http://www.revilloc.com is the
answer.
Tips, tricks and articles for programmers of all languages on
http://www.sourcecodecorner.com
Planning a wedding? http://www.bmcweddings.com
Advertise your car on http://www.drivingseat.com

Jul 19 '05 #1

Subscribe Post Reply

1365

Similar topics

enclosing csv fields in quotes

by: Tim Cowan | last post by:

Hi I am trying to create a CSV file with some fields in double quotes ("). I am not having any luck. This is what I want; "8684","COSTING","000010001","REG",X4,15.00, ,14,0,14,9,6 I am...

ASP / Active Server Pages

Changing Colors of fields on a report

by: bill mahoney | last post by:

I have access 2k and I have 2 tables. One is a 7X6 table representing a month with zeroes padding the fields where no day exist. For example February 2003 0 0 0 0 0 0 1 2 3 4 5 6 7 ...

Microsoft Access / VBA

Create Table, Add fields, Relationship and Link

by: Melissa | last post by:

I have a frontend file named CustomerApp and backend file named CustomerData. CustomerApp is at C:\Customer Database and CustomerData is at S:\Customer Database. Could someone help me with the code...

Microsoft Access / VBA

How to compare fields from similar tables

by: Megan | last post by:

Hi everybody- I'm helping a friend with a music database. She has an old one and is creating a new one. She wants to compare records and fields in the old database with records and fields in the...

Microsoft Access / VBA

Reports with lots of fields not otherwise in database

by: Darryl Kerkeslager | last post by:

As the subject above hopefully makes clear, I want to do several reports, "with lots of fields not otherwise in database". These reports also have variable-length text. I have defined the...

Microsoft Access / VBA

Number of fields in a query

by: Proteus | last post by:

Hi, I'm using access 97 on windows 98. I have table with 162 fields in it. I need to withdraw this information in a (totals) query with 164 fields (162 "avg" fields and 2 "count" fields). When I...

Microsoft Access / VBA

Command Line Compiler, CS0116: A namespace does not directly contain members such as fields or methods

by: Genboy | last post by:

My "VIS" Website, which is a C# site created in VS.NET, Framework 1.1, is no longer compiling for me via the command line. As I have done 600 times in the last year and a half, I can compile to...

C# / C Sharp

Problem in displaying few fields......... using DATA READER.

by: Vigneshwar Pilli via DotNetMonster.com | last post by:

Hey, Well, I have a Problem. I have designed a table which has few fields which are being declared in the database of type .... char of length 10. and other fields with varchar 50 and...

ASP.NET

access struct member fields dynamically

by: sean.scanlon | last post by:

can someone help understand how i can could access a struct field dymanically like: foo->fields ? when i try to compile this i get the following error: 'struct pwd' has no member named 'fields'...

C / C++

482

displaying previously entered multiple fields

by: bonneylake | last post by:

Hey Everyone, Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place. ...

ColdFusion

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing