Because I needed to store more than 4,000 characters, I decided to convert one field in SQL Server Database from nvarchar to ntext...now the field holds many more characters without a problem as I examined in my online manager.
But when I tried to display it on my asp page with
Code:
<%=rs("Text")%>
, nothing showed up, and there is no error message. It cannot be null because i checked in the manager...
I m updating a table which contains a field with datatype=ntext.
I use a stored procedure to insert/update data in it.
SP's parameter's data type is ntext.
Following is the code in which i created the parameter.
Code:
SET objParam1 = objComm.CreateParameter("@xmltempSrc",adLongVarChar,adParamInput,1073741823,txtXmlConte nt)
objComm.Parameters.Append objParam1
when i execute it, it give error as :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type text to ntext.
I m using Sql server and ASP.
I am converting an Access Database system to SQL Server. I am experiencing the following with an ntext field. It was converted to this from memo using the upsizing wizard.
TableName.open SQL, cnn, adOpenForwardOnly, adLockReadOnly, adCmdText
Response.Write(TableName("NtextField"))
Response.Write(TableName("NtextField"))
The second Write displays nothing.
If I change from adOpenForwardOnly to adOpenStatic it works fine and both writes show the contents of the ntext field. Can anyone give me some insight into this?
If I have a SQL 2000 database with a table that is using 2 Ntext fields with a lot of data in them, can I convert them to VarChar(8000) fields safely? Will there be data loss? Would it best be done through Enterprise Manager?
View Replies View RelatedI'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
how to update and retrieve ntext fields in my asp code:
View Replies View RelatedUpon retrieving a recordset from a MS SQL database I can't Response.Write those columns that are of the data type text or ntext.
I'm using the shorthand: <%= oRS("COLUMN_NAME") %>
Other fields work fine, so I know the query is returing at least one row.
Any ideas on this?
I am moving from a Windows 2000 Web Server to a Windows 2003 Server.I have converted all of my old CDONTS to CDOSYS with no problems. However,I am having major problems with getting my asp pages that have both MySQL and CDOSYS
on them to work.I get the following error:HTTP 500 Internal Server error
There is a problem with the page you are trying to reach and it cannot be displayed
I'm using classic ASP. I made a change to a page and I got a Page Cannot Be Displayed error. I changed the code back and now I get the same thing. Other pages can run and access the db server.
I tried taking out includes and bypassing some code. I've also checked both the Application and Event logs on the server and there doesn't seem to be anything obvious there. I'm not using any components. Can anybody give me an idea as to the types of
things that cause this problem?
I've got an asp page that allows users to input quantities of certain items. When they click the "Total" button, the page is submitted to itself and a total for their selected items is displayed, similar to any online shopping cart.
When all items have been selected, the form is submitted, and their taken to the next page. If they choose the browser's "Back" button, or a "Cancel" button on the asp page, they get the Page Cannot Be Displayed Error. However, if they never update the total, and instead enter all the quantities and then submit the form, withing submitting back to itself, the browser's "Back" button and the asp "Cancel" button work fine.
It appears the back button doesn't work when the previous page has been submitted to itself. Does anyone have any suggestions? Is it a bug in my code or possibly an IIS issue?
I have a form from html called "rcf" and it suppose to get the data from users and send it to the database.but from my form to my add_rcf.asp page I get a "The " message.I uploaded the files.
View Replies View RelatedI get this page cannot be displayed every time i try to run ASP pages on Win 2k Server IIS5.1 . I know that the guy who's server it is had run a couple of lock down tools after his server's security was compromised.
Could this be part of the reason why? I had a look at his configuration and .asp files were pointing to 404.dll? I changed it to the asp.dll in inetsrv directory but that didn't help as well as restarting IIS.
i am tryint to access this ASP website, but it keeps giving me the msg PAGE CANNOT DISPLAY. when i send the url to my friend, it load for them just fine. can someone tell me if ther are any option i have to chang or any way of solving this problem?
View Replies View RelatedWe have two websites:
1. On Internet
2. On INTRANET
Anyone with any internet account can access to the first site, but to enter to the 2nd, u need to have a special internet account (say, a certain supplier).
The general menu is on the Internet website, but one of the items in the sub-menu, links to a page On the INTRANET. If u r not authorized (=did not use the certain internet account), then u get the page "The page can not be displayed".
How do I redirect the "page can not be displayed" to the help page, and of course, redirect it ONLY when the "page can not be displayed" page is there b/c of linking from this sub-menu, or b/c of trying to reach directly to the Intranet certain URL that this sub menu links to.
I have a page that displays images. However, at times if I have changed the actual image but have kept the same name and src, the old image still displays when I run the page. I have cleared the files and cookies and sometines this helps but not always.
Is there something I can do to force a change?
I know this is a simple problem,what are all the causes of this problem? This occurs to only when I don't login to the web server.
View Replies View RelatedI am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies View RelatedI just installed IIS on my local system. Just wanted to check if asp was enabled too. but when i run the code on the browser it displays asp code. What am i missing out here?
View Replies View RelatedI have a dynamically populated page, and for one of the records the page is not completely displayed. When I click view source, the code is complete but about half of the code isn't shown on the page.
View Replies View Relatedi have 25 fields on a form vertical display and i want them to be displayed horizontal. i want to support my idea of horizontal display to my manager the reason why i want horizontal display is because the user wont have to scroll down. so i need some articles from the web or technical articles which support my idea.
View Replies View RelatedI have done search on the board (and google too) to find a way to display properly my HTML code that are already inside the text in my database like < br > and < i > and so on. but when I see the result in my browser (using ASP) I see the HTML coding and not the result of the code.
I have found here in the Funky Functions in ASP thread probably something useful but I cant make it work (second post, the one made by aspapp).
I had a problem which will cause the user to get an error page cannot be displayed. But this error only happened on one of my users, the rest are able to login to my site.
what might had caused the user to get "page cannot be displayed error"? Is that due to internet security settings? Or error with my code?
i've created a simple web app that allows users to enter in
information about a project in a web form and save that information to
a database (Access). After a user enters in all the information, she
can click on a link to go to an index.asp page that displays all the
projects that have been added.
the problem i'm having occurs after the user enters in all their
project information. when the user goes to the index page, the index
page is suppposed to retrieve all records and display them, but it
doesn't.
even after hitting the Refresh button in the browser, it
won't display the latest project that the user just entered. however,
if i add a second project and then go back to the index page, it will
work fine and display both the first and second projects. so, it's
like the first project won't be displayed until i enter in another
project after it (like the first project is stuck). does anyone know
what the problem may be?
I have a dynamic table which is checking data from Access database and filling up the table appropriately. In my development environment of Windows 2000, the table displays properly but after hosting (that same source file), the table is not displayed. The error occurs at the following point:
Code:
<font face="Verdana" Size = "2"><td width="70px" height="25px" align="center" <%=colorBG(weekNr,dayLoop,intPeriodStart)%>
</font></td>
The host server is using windows 2003, what could be the problem?
I have a field from my recordset called RS("Password").
If I wish to display each character as an asterix '*' how do I go
about it.
I've seen the replace function, but cannot work out how to do it for
how ever many characters there are in the record ?
After rebuilding our web server from NT 4.0 IIS 4.0 to Windows 2000
IIS 5.0, I'm constantly getting HTTP Headers posted to the top of the
HTML source (generated from ASP pages of course). This only seems to
happen upon hitting the browser's (IE 6.0) "back" button and not even
100% of the time when hitting the back button. Here's an example of
the source that is generated: Code:
When displaying data from a database, how can I limit how many columns are displayed on the page?
I am trying to build an image gallery, and I want it to be 5 images across by x number of rows. I know how to make each image it's own column, or it's own row, but I don't know how to limit how many columns are displayed per row.
I have a site on which the visitor completes a form. When submitted, the form field details (email address, business, etc) are stored in an MS Access database.
I have to log-in to my server at the moment to see how many forms have been submitted.
Is there a way - I am sure there must be - of linking this MS Access database, that is, the number of forms submitted to it (which is not the same as counter 'hits', because people can visit the site without submitting the form), to an ASP/HTML page which displayes the figure in chart form month by month?
I got a test asp page which connects to Northwind.mdb database. This page
pulls all the rows from the Customers table. One column i.e. GoodStatus has
been added to the customers table. The following is the code to display all
records of the customers table with some customization. Code:
I am pretty new to asp.net, and have recently taken over a project. I have
gotten to the point where I am about to release my changes, but for some
reason when i build the project in release mode and launch in in IE I always
get a "The Page cannot be displayed" page instead of my login form.
Anyone have any ideas? The applciation works fine in debug mode, its just in
release mode that this happens.
I have this asp search engine that displays the urls for the files found, only the display shows %20. I need to remove the %20 and display a space instead; is there some way I can mask or remove that for displaying results for users?
View Replies View RelatedI want to display a different message deppending on the amount of stock left. For example if there is no stock i would like to display "out of stock", if the item is in stock display "in stock". Code:
View Replies View RelatedThe following code was suggested by one of the users in this newsgroup when a pdf file was requested by a user from an asp page. I used the similar code in my page and the very interesting thing is when the pdf is displayed on the fly, the whole page is a gibberish code in stead of a normal pdf file. But it displays fine if I just use a link to a file on the page. Can you tell me what's the possible reason will cause this problem?
View Replies View Related