Im trying to text from a scrolling text box into my database but it only inserts the text before return is pressed. Im the field its being entered into is a memo in access.
is there a way to get all the text in the box to be inserted?
I have encountered a problem when a user submits text which contains commas and quotation marks.
Code:
Function ChkString(string)
If string = "" Then string = " "
ChkString = Replace(string, "'", "''")
End Function
I am currently using the above code, but what i have realised is that i am losing whole text that does not get entered into the database, when i wrap commas and quotes around it.
I'm trying to create a form that allows me to modify the contents of list. When the user clicks on the modify button, it takes them to a page which displays the quantity of items they purchase, and allows them to update that quantity. So the quantity is shown in a textbox, and the content of the text box is drawn from a rs("content").
But the page is crashing when I run it. I'm having trouble getting the response.write textbox line to work. Here's the code:
response.write "<td align=right><input type="text" name="quantity"
value=" & rs("qty") & "></td>"
This is the line that is causing the page to crash. Can't figure out why. Can someone give me some insight into this?
I'm trying to put some text into the database using ADODB.Command object. Seems like a reasonable thing to do and I can do it. But in this instance my text is an HTML code which contains many quotes. But i have to save it as is into the database field.
I use:
INSERT INTO (f1, f2) VALUES (v1, v2) comand. But since my v2 contains some quotes in it, (many quotes), I get an error. (it works otherwise). Is there any way ?
I need to populate a field with html formated text. I'm using a simple form field to do so.
When I use a textarea to return the record, it comes out formatted, but when I use a Response.Write command, it comes out as plain text. Anyone can tell me how to make the response.write publish formated text?
I am working on a asp and sql website that I did not make. It runs an asp based content management system, where users can enter news articles. They enter the "body" into a text box/area and can add images separatly. The image will show up to the to left of the article.
This goes into a SQL database, and gets pulled out by asp for the webpage. I want to make it so a user can add in an image into the body of the article ( like in a word document ) and have it show up where they put it. What is the easiest way to do this. Both easy on me and the user.
Does anyone know how I can insert daynamic text box data into a SQL Server database? I have text boxes that are being generated dynamically and I want each of those values inserted into the database that hold the results. I'm not sure how to write my loop statement.
View Replies View Relatedhow to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI use server.execute in a table and I dont wannt to change the sizes of table so I want to use scrolling bar but how can I do it.
View Replies View Relatedi would like to do a photo carousel function similar as the http://flickr.com/photos/69864550@N0...n/photostream/. the function i would like to do is on tis flickr.com web at the right hand side for tat photo stream
http://i263.photobucket.com/albums/i...2008/image.jpg
let say in my album have 100 photo. and from tis funciton, it will not load out all my 100 photos when the page is loaded. it will load the others photo when i click on the NEXT arrow button. i need some help on tis funciton and implement it with ASP VBscript code.
I am trying to make a upward scrolling text box, I think this was done with javascript. But of course the site that I saw it on won't let you view the source of it. It is at this site <a href="http://www.survey-review.com">http://www.survey-review.com</a>. I have also looked for a tutorial on how to do it, but can't find one. Can anyone help me with how to do it?
View Replies View RelatedI have deployed a page with 3 frames of which one of them is a asp page.
Whenever the content of the page increases scroll bars apperar individually for each frame ruining the look of the page. I tried using tables instead of frames by giving "server.execute()" inside <td>.The drawback is that server.execute() doesnt accept absolute urls.Server side includes also cannot be used because the page to be loaded is decided dynamically based on the request.
How do i load absolute urls ...?
I have a page that pulls info from a SQL DB and displays it for the user. Everything is fine now 'cos I only have ten entries in my DB. When finished, there will thousands of records and what I see is an endless scroll or page down for the user. But what I want is to display a MAX of 15 records per page and have the others displayed on following pages.
So how do I get my pages to continue on page 2, 3, X XXX and have it so that clicking on any of the pages jumps to the corresponding page. You can actually see what I am looking for here at sitepoint. In their own case, they have it displayed within page ranges.
how to prevent a button from scrolling i.e keep its absolute position same on the page.
View Replies View RelatedWe have dropdown on ASP page. The problem is we have about 900 items in the
dropdown. Users scrolling through the list have become very frustrated in
the past.
Can someone suggest if there is another way of implement a dropdown where
the datalist is as big as ours.
I am looking for something like a listbox in VB where you can start typing
the characters and the databelow moves accordingly until you have found what
you want.
Is there anything in ASP/HTML to achieve a similar functionality.
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.
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?
There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.
View Replies View RelatedI get the following error message
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/weblinkup/chat.asp, line 1775
oConn.Execute("INSERT into chat (username,nametext,roomname,type,priv,thetime,msg) VALUES ('" & username & "', '" & username & "', '" & Roomname & "', 'msg', '0', '" & now() & "', '" & username & " has just said " & emotetarget & "." ')")
what the problem is with the code?
i have a database Access with Book Table and Author Table. now i have created a form which inserts info submitted into the Book Table, yet it keeps giving me this error "You cannot add or change a record because a related record is required in table 'Author' " while the names of the authors are all registered.
it works in Access but not in asp it doesn't make much sense. People just enter the names of the books which their authors are in the Author table. it keeps giving me error. how to know why this is so?
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?
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.
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?
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 RelatedI 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 RelatedI have an error as follows:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.
My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?
My codings:
strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =
'
')"
Response.Write ("test")
Set oRS = conn.Execute(strSQL)
I had some Error when i write the update sqlp query
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:
INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')
I'm wondering if it's possible to create an instance of an ADO Recordset and add values to it by ASP ??
Ex :
I have 2 arrays :
arr1 = Array(1,"allo")
arr2 = Array(2,"bonjour")
Is it possible to add these 2 arrays into a Recordset to manipulate de data more easily?
If yes, could you provide me with a little example to see the synthax, because I tried almost everything and it didn't worked at all
how do i design my site interface such that users can insert smilies along with text in the form field just like it is here on sitepoint...
View Replies View Relatedi've tested my code and it seems to send back an error, when i'm trying to insert a record into my db (sql server)
Basically when I udpate one of the records it's fine ( I update at a certain "productID")
But when I insert a new record it sends back an error telling me that my "productID" can't be a null value?Any ideas on how to fix this?
When I insert info into a DB from a form, it cuts the string off at the first apostrophe (").
How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data: