I'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:
I am using CDONTS to send mail to the user from my ASP application. However, the code doenst works all the time. I am able to get mails but nothing happnes most of the time. The code works maybe once in 20 tries. What could be the reason?
i posted earlier, and the response seemed to be there is another dll i need to use the cdonts object, i used it fine for awhile on my old setup, i upgraded to 2k3 and it errors up as if cdonts isnt an object. So is there a dll i need to have to use the cdonts object in iis 6 or do i need to rewrite my code to use cdo? (if so, please provide asp 3 example on how to send an email with recepient, sender, body and subject)
I have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
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.
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 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.
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?
I have a query in ASP that does a select * from table It doesnt retun all columns! When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
I wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get it?
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
i use a IIS 5.1 with win XP with the newest updates etc. its possible to start aspx and html files but not asp files what could it be ? what can i check ?
Can a ASP work like a CGI.(Email Scripts) ? Can a ASP script for email will work, if a Script is on 1 server and form(html.form) is on another server and a thank you page is on 3rd server. Like if u don't know about a CGI there are many websites who give you permission to use their script by editing little bit in yours form and place them on yours server website, there are number of site.
And 1 more thing I want to ask is if some one use a windows server he have a form html on that server, can he run asp script which is on Linux server to get form result on his desired email id.
I am trying to construct a sub procedure that concects to db , executes a stored procedure and returns a recordset. Connection to db and executing the stored procedure works fine.
The problem is that when I call the sub in the asp page to be executed the recordset is refused to be returned from the sub and the recordset itself does not appear to be constructed. or in another words the error displayed is: 'object required' --> refering to my recordset --> 'rs'
I do not know why, can any one tell me the reason, I tried much but with no result. NOTE: For testing puropses I looped through the recordset isnide the sub itself and it worked fine Code:
Is there somebody who can explain to me how I can use a Global.asa to store Functions and Variables in it? I understand that there are 4 events that can be used in a global.asa : Application_OnStart, Application_OnEnd, Session_OnStart, Session_OnEnd
But still i don't get how i can CALL functions of variables. Because with those 4 things they start all in the beginning or in the end of a session or application.
For example i use an encrypt function in different pages, can i just put it in de global.asa and call it when i need it?
I have an asp page. In this there is a form when submit it have to chech if the fields are not emtpy.When it not empty it wil insert into a database an a mail.If a field is empty it send it anyway, it doens't do the validation. Here is a part of my code:Code:
<% if request("action") = "Verzenden" then datum = request("dtmmeldinghelp") if datum <>"" then 'I have tried also: if len(datum) <0 then response.Write("<html>" & "<body>" & "Fout" & "</body>" & "</html>") else ' here come my sql insert to code and the code for email ' this works fine %>
I am trying to add a button to a menu which it's action is conditioned by a session variable. The button shows up fine but I get no action from the button being clicked . The variable does have a valid value. If anyone can help me out with this it would be greatly appreciated. The code follows:
<SCRIPT LANGUAGE="VBScript" FOR="Button1" EVENT="onClick"> If Session("RVQuoteAuthority") = "Y" then Response.Redirect(Quote.asp) else MsgBox "No Authority" End If </SCRIPT>
Talking about the cdonts objects.. i want to send the email in windows xp.. i downloaded cdonts.dll and registered it.. but still i am not able to send the mail.. is it so that i need to set the settings in the Virtual SMTP server in IIS ?
I have not been working with ASP for too long at this time and am not real familiar with a lot of things about ASP. I have searched for articles on the following question but not come up with any definite answers. Code:
I am trying to get ASP to work with IIS and i keep getting page cannot be displayed when i try to open asp pages? Do i have some settings wrong somewhere?