473,395 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

String getting chopped up

I'm submitting a string of data, with several words in it. When I try
to retreive it from the database, I'm finding the words of the string
have been removed. For example, if the string entered is a person's
title, such as Vice President of Finance, it is only showing
VicePresident
then nothing else is showing. What could be the problem?

Thanks,

Bill
Jul 16 '05 #1
4 1944
Hi,

What is the type of the field in the DB where the string is stored? Maybe it
is too short so the DB truncates it.

Albert Ahtenberg
Jul 16 '05 #2
> What is the type of the field in the DB where the string is stored?

Albert, in answer to your question, the field is a varchar 100 so I
know that's not what's happening. I have a feeling there is something
to do with of of the fields not being surrounded by quotations, but I
can't figure out which one. It seems to happen whereever there is a
space between words. So if I have VicePresident it will work, but if I
have Vice President, two words, it will show Vice, but then it won't
show the rest of the string. What could this be?

Thanks,

Bill
Jul 16 '05 #3
On 16 Jul 2003 17:41:07 -0700, bi***********@gospellight.com (Bill) wrote:
I'm submitting a string of data, with several words in it. When I try
to retreive it from the database, I'm finding the words of the string
have been removed. For example, if the string entered is a person's
title, such as Vice President of Finance, it is only showing
VicePresident
then nothing else is showing. What could be the problem?


Not enough information to say.

Post a (short!) sample of code that demonstrates the problem.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 16 '05 #4
Bill wrote:
I'm submitting a string of data, with several words in it. When I try
to retreive it from the database, I'm finding the words of the string
have been removed. For example, if the string entered is a person's
title, such as Vice President of Finance, it is only showing
VicePresident
then nothing else is showing. What could be the problem?


Often when this happens, it's because quotes are left out of the form.

ie.
<input name = position value = <?PHP echo ($_GET['position']); ?> >

I'd check that first. If not, post a code snippet.

Shawn
--
Shawn Wilson
sh***@glassgiant.com
http://www.glassgiant.com
Jul 16 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bill | last post by:
I am passing a string of text between a page and a database. It is a book title, which consists of 2 or three words, and only the first word is passing to the database. The page that passes the...
4
by: Paul Jackson | last post by:
I have the following situation: class Y; class Z; class X { public: Y y; Z* z; };
26
by: Kai Jaensch | last post by:
Hello, i am an newbie and i have to to solve this problem as fast as i can. But at this time i donīt have a lot of success. Can anybody help me (and understand my english :-))? I have a...
4
by: Ray Mitchell | last post by:
Hello, My understanding is that C++ string class objects still terminate their strings with a '\0', as do strings in C. If this is the case (please tell me if it isn't), it appears that the...
0
by: Roedy Green | last post by:
I notice if I make padding too big on an element, when it is in a table it gets chopped off. Is there anything other than the padding on the TD that could be affecting this? -- Bush crime...
6
by: Mark | last post by:
Hi, My page has a table with many columns such that the right-side of the table gets chopped off when printed. I specify a table width of 100%, but otherwise no cell dimensions are specified. ...
6
by: Pucca | last post by:
My container with 2 panels containning Treeveiw and Listview controls are chopped off on the top by the toolstripmenu when I dock the these 2 contols in the parent container and the container is...
26
by: drako | last post by:
Hi, I'm a bit stumped as I am getting a "Notice: Array to String Conversion" error when trying to do something that on the surface should be a very simple task - create an array, and write a set...
2
by: =?Utf-8?B?S3VtYXI=?= | last post by:
I am using granados telnet client for connecting to the telnet and get the data from it. Every thing appears to be going smooth. But for some reason when I try to write the byte data to a string or...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
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...
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.