Getting Text Into SQL
I have an ASP page to be used as a Softball Roster. The user will enter their roster information and the information will then go into a SQL database. My problem is this... I keep getting this error "String or Binary Data would be truncated". I figured out what this message meant and I have printed my variable to the screen to see what I get.
As an example what I get for my variable PlayerFirstName is Joe, John, Henry, Alex. I only want one name at a time so that I can import them into SQL. How do I parse my line apart so that I can loop through it and pull off only one item at a time and put it into SQL?
View Replies
ADVERTISEMENT
I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
View Replies
View Related
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
View Replies
View Related
I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?
<textarea name="textarea" cols="35" rows="5"></textarea>
In the text area above, can I say limit the person filling in the text area to say 100 characters?
View Replies
View Related
I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.
The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:
With quotes around <%= vdesc%>
<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>
And I tried it without.
View Replies
View Related
I have text in a field coming from a database. The text has various
forms such as:
text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...
how can I parse this with a reg ex? I tried this:
(.+);? or
but it only captures 1 submatch (text1) and only if theres an "or"
after it
I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.
Anyone know how to do it?
View Replies
View Related
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
View Replies
View Related
I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
View Replies
View Related
I have a search page, after search returns value I want to display fields in text box instead of table.
View Replies
View Related
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies
View Related
I'm trying to make a text box for comments. I know how to put one value into a text box like name, but i'm not sure how to pull multi-values. I want to be able to display the time,user and comment in a text box. I don't know how to go about this. The comments are stored in a different table and there can be many comments for one policy.
What i did was i have asp code the displays all the comments and puts it into a table, but i want to put this into a text box not sure how to go about it. Here is the code i'm using. the reason why i need it to be in a text box is so the user can update it, does anybody have any ideas. Code:
View Replies
View Related
I have a drop down as below.
<select id="drp1">
<option value="1">One</option>
<option value="2">Two</option>
</select>
I need the text value of the drop down box.
Request.form("drp1").value is giving 1 , but I need the value "One". How can
I do this.
View Replies
View Related
1) How do I check for a text box with a null value?
2) How do I check for a text box that doesn't have a valid number/ integer inside it?
View Replies
View Related
I am trying to create a text box in ASP which automatically populates itself with the person's name who is currently viewing the page.I want it to retrieve the name from Active Directory.The text box populates itself when the page is loaded.
The Active Directory code for name is 'cn'.So when logged on users name = 'cn' display the name in the textbox.
View Replies
View Related
I'm putting a standard mail page together, that will allow my users to
sent templete emails out to people.
The files are stored in textfiles.I have come up with a script to produce the names into a Select list, but know i'm wanting them to be read into a textarea box,to allow me to submit them into from the form into the sendmail.asp page! but the only way i can pass them out, is into a iframe, whichd oesn't seem to allow me to then pass them into the sendmail.asp page.
View Replies
View Related
how can i write a line to a text file? also, how can i put every line of a text file into an array - and see whether a value mathes any of the lines in the array?
View Replies
View Related
I'm writing an intranet and I need to put something like a non-editable
scrolling text box on the home page where daily announcements can be placed.
I've tried adding a scrolling text box, but I am not sure how to make it
non-editable.
Is there any way I can fill the textbox using something like
textstream? I would imagine one person in the organisation would be in
charge of adding this text somehow. I'm a bit lost in trying to find the
best method.
View Replies
View Related
Do you guys know how to parse an input(text) to verify if it contains special characters. The input should accept numbers or letters only.
View Replies
View Related
I know that trim removes white space and the LTrim and R trim removes space from the left or right but how would i trim a string after 20 characters so that i could add ... to the end of the new trimmed string???
View Replies
View Related
I have a form with multiple records.
My intention is to have the user click a checkbox for each product he wants.
Then submit the form placing multiple items in his cart.
If I use a text box like the following and enter a 1 for each product,
submit, no problem.
The user gets the products he wants.
<input name="qty" type="text" value="0">
However, if I use the following checkbox code, and assuming the user checks
4 products half way down the page, he will get the first 4 products in the
recordset. If he clicks 1 checkbox, he will always get the first product,
not the product he chose. <input name="qty" type="checkbox" value="1">
What I have found is when I submit the form to a blank test page using
checkoxes or text boxes, there's a considerable difference. The text boxes
deliver a comma delimination for each occurance. The checkboxes only offer
comma delimination for each checkbox that is selected. At this point, I'm
assuming that's the difference between the two and it cannot be changed
through HTML.
View Replies
View Related
how do you go about passing a name on after a login->doLogin->MembersArea so that you can print Welcome username?
View Replies
View Related
Just wondering if anyone knows of any scripts/component that will allow me to create an image of a text on the fly?
View Replies
View Related
I would like to do some modifcation based upon the value on a text field. What I would like to do is have the text turn bold face based upon the value of the text field.
For example if the field contains a value 4 I would like to have the text some where else in the program change into bold type.
View Replies
View Related
i need to make some text editor like this in the sitepoint which we enter our threads
i saw it in many asp sites with many enhanced features so how can i desig some 1 or get a it from the web
i need to unserstand it's idea how can i format the text into html format and how can i save the formated text into the database and the important point how can i display it as html
View Replies
View Related
When i send a text string to my database linebreaks are stored, but when i call it from asp to the page all linebreaks are lost.
this will reformat text to look different than i was initially typed, how can i make the text shown on webpage in orginal formating.
hope im clear on this or ask and i will elaborate.
View Replies
View Related
I have a form with a select control called "Last Name" and 1 text box called " First Name". In the select drop-down I have a list of last names pulled from the database. Also the second text box first_name value will be pulled from the database also.
When a user selects a last name from the list I want it to automatically update the first name textbox based on their selection. Ie. The persons first name is put into the textbox.I need to take the values of both(First Name and Last name) and send them to another page
View Replies
View Related
How i can get a text field that would accept apostrophes?
here's my code:
Title = Replace(Request.form("AddTitle")
Message = Replace(Request.form("AddMessage")
Author = request.Form("AddAuthor")
TimePosted = request.Form("AddTimePosted")
DatePosted = request.Form("AddDatePosted")
sql="INSERT into NEWS (title, message, author, date_posted, time_posted) "
sql = sql & "VALUES ('" & Title & "', '" & Message & "', '" & Author & "', '" & DatePosted & "', '" & TimePosted & "') "
Conn.execute(sql)
Response.write sql
View Replies
View Related
In my form I placed a text box, in which I want when the users writing something some choices from a database table to be presentes for example:
if they wrote
G
a drop down list to be showned which contains.
View Replies
View Related
i have tried to align the text and a textarea on top, but fails.
<tr>
<td width="150"> </td>
<td width="150" valign="top">Description :</td>
<td width="300"><textarea name="desc" cols="34" rows="6</textarea></td>
<td width="160"> </td>
</tr>
the codes above show the "DEscription text at the buttom level. How can i place them at same level?
View Replies
View Related
I would like to upload files to a server and input data from a text box into a database. I can upload the file and insert that data seperatly but have problems doing it together.
The text box is named txt_name so I know that I need to add the code txt_name = upload.form("txt_name").
I'm not sure where I need to add this code. Using the code from freeaspupload.net I have two files the uploadtester.asp and freeASPupload.asp. Where should I put the code listed above and where do I need to insert the Insert Record Code?
View Replies
View Related
I just modified a SQL table field's datatype from char to text to accomodate
more text, and suddenly the results are not being displayed on my webpage.
Has anyone encountered this before?
View Replies
View Related
I have an ASP site pulling from a SQL Server. When I pull a text field from the database into a text area, it keeps the formatting. If I pull the data from the database on a response.write, all of the formatting is lost. how can I prevent this from occuring?
View Replies
View Related
I have a text file from which i want to import data to access, does anybody know how i can go about this or where i can get information about this subject?
View Replies
View Related
