Dropdown Mapping Doesn't Work
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>
View Replies
ADVERTISEMENT
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?
View Replies
View Related
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)
View Replies
View Related
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:
View Replies
View Related
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:
<%=rs("Text")%>
to display the ntext...and there is nothing.
View Replies
View Related
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:
View Replies
View Related
What is it about mapping that's fixing my problem, b/c the UNC will not work?
I would prefer to use the UNC if possible in my current situation.
Here's my code:
Map - ImagePath = "v:" - this one works but UNC doesn't
UNC - ImagePath = "srv-file-bLic Pic"
Response.write "<img src=" & ImagePath & RTrim(LastName) & Left(LTrim(FirstInitial),1) & Right(SocSecNum, 4) & ".jpg width ='100' height ='100'>"
testimage = ImagePath & RTrim(LastName) & Left(LTrim(FirstInitial),1) & Right(SocSecNum, 4) & ".jpg"
Response.write testimage
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
I was wondering is there a way to map a network drive a on persons machine with a online gui interface?
Is there a way user 1 can map drives on THEIR computer using an online interface?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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
select *,missingcolumn1,missingcolumn2 from table
View Replies
View Related
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 .
View Replies
View Related
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
View Replies
View Related
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?
View Replies
View Related
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).
View Replies
View Related
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.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
View Replies
View Related
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
View Replies
View Related
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 ?
View Replies
View Related
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.
View Replies
View Related
cannot using onAfterPrint in IE 6.0, the page can print but cannot close.
Why??
my code like as below
<body
:
<script language="javascript" type="text/javascript">
<!--
window.print();
//-->
</script>
</body>
View Replies
View Related
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Bug Status Board</title>
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rs = server.CreateObject("ADODB.Recordset")
sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION,"
sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, "
sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc"
sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex =
n.bugindex "
set rs=conn.Execute(ssql)
and this is the error message that I get Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'
I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
View Replies
View Related
I copied ASP/VBScript code from several sources and adapted it to my page and variables. Here is my current code for implementing CDO:
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
I've just moved all asp file from IIS4/5 to IIS6(2003), but they don't work.It there any trick?
View Replies
View Related
I need to provide a pulldown with work weeks displayed.Is there any easy way to do this?
I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.
View Replies
View Related
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
%>
View Replies
View Related
i built this test program:
<HTML>
<HEAD><TITLE>Test</TITLE></HEAD>
<BODY>
the time is <% = Time %>
</BODY>
</HTML>
It does not show the time! very basic probably but not for me.
View Replies
View Related