I try to use the below code to do mapping but, i saw no value in my dropdown. I'm using classic ASP, with MS SQL Server 2005. I have check, There are value in rs("statusid") and status table. Anyone can detect the problem here?
<select name="status" class="FormTextField" id="status">
<%
SQL = "SELECT (CASE WHEN statusid='" & RS("StatusID") & "' " & _
" THEN '<option selected>' " & _
" ELSE '<option>' " & _
" END) + statusid " & _
" FROM Status ORDER BY statusid "
Set RSTypes = MM_cSupport_STRING.Execute(SQL)
Response.Write RSTypes.GetString()
RSTypes.Close
%>
</select>
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'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 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 have created my asp pages in "D:/test" . This i have created as a virtual directory. i am having some files in "D:/download/cont/somename" From the asp page i want to access the files in the d:/download/cont/somename folder. Here somename changes according to username. i.e first i want to check whether this path is valid and then get all the files from it but its giving me the following error
Server.MapPath(), ASP 0174 (0x80004005) An invalid '/' or '' was found in the Path parameter for the MapPath method. /test/contractsfile.asp, line 11
code: somename = Request.cookies("username") source = ".. est" & "/download/cont/" & somename if fs.folderexists(server.MapPath(source)) ---------------------------> line 11
Is there some good mapping software out there that integrates well with ASP apps? I need to be able to pass in several addresses, and display a route on a map with driving directions.
Does anyone have an example of field mapping? I am trying to write an app that reads a .csv file and then allows a user to map those .csv fields to existing SQL fields.
I have the reading of the .csv & writing to SQL, but hit the wall trying to get a mapping process to work. Ideally, I would check off a field from the csv and check off a corresponding field in the sql field then hit a map button and it would set the fields in the sql statement according also removing those two selections.
I was susseesful in mapping remote machine with vbscript. Now I am building the same tool with ASP .I am using the same code but its not working. Below is the portion where I am mapping the drive: Code:
I am thinking of mapping out a website. The website is very large and the reason I am doing this is to find out which files are redundant and how I can go about tidying up and simplifying the code.
Can anyone recommend any good mapping tools? I am working for a company which gets all the Microsoft development tools. If anyone can recommend a Microsoft tool that would be better as I would already have access to it.
I've setup several FTP shares on IIS 5, where some of the shares are located on another computer, while other directories are on the local computer.
Is there a function similar to server.mappath that I can use to return the physical path of a FTP virtual directory using ASP?
For example, I have a virtual directory called TestA located at C:TestA on the local computer running IIS 5. I have another virtual directory called TestB located at DevserverTestB where Devserver is another machine on the network.
In my ASP code, I need to be able to access the physical directories directly and I would like to avoid having additional code to deal with hard coded directory paths.
Is there something similar to the command server.mappath("TestB") which would return "DevserverTestB"? This way, the physical path is transparent and I can treat local and network shares in the same way.
I am trying to write an app that reads a .csv file and then allows a user to map those .csv fields to existing SQL fields...
I have the reading of the .csv & writing to SQL, but hit the wall trying to get a mapping process to work...
Ideally, I would check off a field from the csv and check off a corresponding field in the sql field then hit a map button and it would set the fields in the sql statement according - also removing those two selections.
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?
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
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 %>
