I have a script in ASP:
If strReport = "OrderDetail" then
strReport1 = strReport & ".rpt"
End If
If strReport1 <> "" Then
strReport1 = strReport & Year(strPeriod) & ".rpt"
End If
Now based on the kind of value in strReport1, I would like to do 2 different set of work.... Like for instance,
If strReport = "OrderDetail" then
call SubReportDB
End If
If strReport1 <> "" Then
Call SubOrderDetail
End If
Is that the right syntax?
I'm building a system that flags Spam phrases and brings them to the attention of admins. I have a table with a list of about 90 terms and I want to show any rec ords that display them so Admins can determine if they should be deleted. The method I'm using is:
Building String
Code:
oString = "SELECT int_RecordID, txt_RecordName, txt_RecordDescription FROM dbo.qryRecords
WHERE txt_RecordName LIKE '%Viagra%' " & Call subSPAM & "
ORDER BY dte_RecordStarted ASC"
how can I can a sub routine in ASP which has been given attribute runat=server
View Replies View RelatedThere is a chapter on SUBROUTINES, FUNCTIONS AND INCLUDES.what is the difference between SUBROUTINES and FUNCTIONS. If not mistaken, in VB, the SUBROUTINES return no value, but FUNCTIONS do have return value.Variable in ASP: global versus local.variable not in betweeb function is Global (what about subrountine, is it the same) and variable in between function is local, am I right?
View Replies View RelatedI am using IIS 5.0, ASP and VBScript. I am puzzled by recurrences of errors when I nest subroutines, and I'd like to know if there are rules for that which I don't know. Would functions work better instead? I am not much of a coder.
View Replies View RelatedIn ASP, if I define a subroutine as private
Private Sub mySubroutine(arg1, arg2)
I understand that the variables I define inside the subroutine are local only to the
subroutine. If the same variable is defined outside the subroutine, it won't conflict
(right?) What about variables that are defined outside the subroutine, but not inside? Are they available inside the subroutine?
I am wanting to call a server-side sub when I click on a button.
Code:
<%@ language="vbscript" %>
<%
sub cmdButton_Click
code
end sub
%>
how do I call this sub from an input button.I have tried the onlclick property but it doesn't seem to work. Is this possible.
Can I have this: Code:
<!-- #include file="myFunc.asp" -->
<form name="myform" method="post" action="<% function1(); %>" >
..form stuff
</form>
I tried it but it was as if the page was trying to process the function before the page rendered.
I'm having a bit of trouble with a subroutine I am calling when it is
invoked for the first time. When the subroutine runs, I expect it to return
a value for every time it is called. However, it seems as though the first
time it is run, I don't get any returned values. However, subsequent
returns will get me something back. Code:
I have 2 MS Access databases DB1.mdb and DB2.mdb.
In DB1.mdb there is a table named table1 and in DB2.mdb there is a table named table2.
How do I write query in ASP to write the records from table1 in DB1.mdb to table2 in DB2.mdb.
i am having a problem with ASP not doing the requestion action of Response.Write based on conditions of a code entered on a first page. The codes are below. I made the second page from template of another that yall helped me with and it aint working.. Code:
View Replies View RelatedWas curious if someone could help me out. I'm setting up a website and using Server side includes to make it easier for maintaining. I've got a contact form that will be included on several pages and I need to know from what page the forms is getting posted from. If I can figure out how to pass one value to a hidden field I can use the form as an include instead of hard coding the whole form into each page.
Ideally the value to be passed could be coded into each page then asp could pick it up and insert it into the hidden field. Any one point me in the right direction for accomplishing this. I don't have a clue about asp other than the basic include statement.
I select 'name' from the customer table.
Is it possible to write it into a cookie?
<%
Response.Cookies("customer")("firstname") = '" & objRecordset(NAME) & "'
%>
when I try to write the above using
<%
Response.Write (Request.Cookies("customer")("firstname"))
%>
i get the following ....
May i know isit can use asp to send an automail when customer fill up the registration form. i need to send a automail to his email verify the customer details. is it any free source code to write?
View Replies View RelatedI writing code that will create asp pages using the file system object.
<%
..
..
'other code here
Response.Write "<%sName=" & Var & "%>"
%>
How can I do this?
If my recordset is empty I want to write "Not Complete" and if there is
a value, I want to write the value. Can someone tell me what I am
doing wrong?
<%
If IsEmpty(rsa.Fields.Item("reclaima")) Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
Also tried....
<%
If rsa.Fields.Item("reclaima") = "" Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
Since ASP server scripts use VBScript by default, does it mean it is
redundant to put the following in ASP page? Then when do we need to use
this? In client-side VBScript?
While doing a response.Write,
I would like to display the text as array item wrapped in quotes. How can I do that?
I write the code as:
'Now get all the sub-reports names to pass the log-on information
For i = 0 to UBound(aSubRpt,2)
Response.Write "webSource0.AddParameter " & u0 & " & " & aSubRpt(c_SRName,i) & ", " & dbd & "<br>"
Response.Write "webSource0.AddParameter " & p0 & " & " & aSubRpt(c_SRName,i) & ", " & dbc & "<br>"
'Response.Write aSubRpt(c_SRName,i) & "<br>"
Next
While seeing the results in the browser, I would like to see
"aSubRpt(c_SRName,i)"
which is primarily
"reportname"
How can I wrap the text in double quotes within a response.Write?
I want to be able to write a gif in my ASP app. Not even sure if it is possible with response.write. I want to replace the 'Member Log In' text with XXX.gif, and still have it linked to login.asp....
View Replies View RelatedI am trying to retrieve info from database and display it in the form. The problem I having is when I try to change the info in the form, it is not changing and I don't know why.
table.fieldname = payroll
Code:
payroll = rs("payroll")
If payroll = "something" Then
payroll = "Some Payroll"
End If
In the form table:
<input type="text" name="payroll" value=<%response.write(payroll)%>>
I want "Some Payroll" to be displayed in the form instead of "Something".
I need to put this whole line into a response.write statement:
field delimiter = """
Code:
<%
username = Session("username")
if ("" = username) Then
Response.redirect "login.asp"
response.Write("Sorry, you are not logged in.")
response.End
End if
%>
How do i write that Sorry, you are not logged in ... to the login.asp?
I've tried using a FSO to write to it directly. I've even managed to write a script for windows scripting host and invoke it from ASP, using standard output redirection (">") to redirect output to a file with no problems.
However, I can't seem to send writes to LPT2: from ASP, even through the other script.
It works perfectly fine if I invoke the WSH script at a command prompt using precisely the same command line, but when I do it from inside an ASP page, I get nothing.
Are there some permissions for the port I have to set or some such? I honestly have no idea how to get it to work.
If it is relevant, LPT2: is a mapped port for a network printer.
Yes, this is related to my previous thread, but I'm down to a much, much more specific problem.
Why do I get an error on executong the following code:
<body>
<%
Response.Write" <script language = ""vbscript""> "
Response.Write" res = MsgBox (""Do you want to edit appliance?"",4,""Edit Appliance"") "
Response.Write" if res=7 then"
Response.Write" window.location.href= ""Appliance.asp"" "
Response.Write" else"
Response.Write" window.location.href = ""Scenario.asp"" "
Response.Write" end if"
Response.Write" </script>"
%>
What is the right syntax, to make that a hyperlink?
Response.Write("<TD>"<a href=""rst("Kotisivu") & ">" & "</a"> & "</TD>")
I am trying to check for the final sql statement before passing it to a
database. I want to build the statement using user input in three text boxes.
However, the sql statement does not give me the right statement. Instead it
gives the following message:
Error Type:
Request object, ASP 0102 (0x80004005)
The function expects a string as input.
/sailors/loginverification1.asp, line 14
CODE:
<%
strSQL = "select PeopleNameFirst, PeopleNameLast, PeopleClubCode from People
where " & _
"PeopleNameFirst ='" & Request.Form(txtFirstName) & "' AND " & _
"PeopleNameLat ='" & Request.Form(txtLastName) & "' AND " & _
"PeopleClubCode ='" & Request.Form(txtPassword) & "'"
Response.Write strSQL
%>
Does any one know how I can position the output at certain point? Such as If I want to print "hello" starting at position 50 from the left in the file.
View Replies View RelatedHow to use Response.write to Output the following Code:
Type id="1"
I tried this one but not working Code:
Response.Write( "Type id="" & "0" &"")
I am creating html string in a component that transforms xml into html.
Works o.k. with small html strings, but takes forever to response.write
big html strings. Is it possible to speed it up?
I am having trouble trying to output an image using Binary.Write. I have a page which displays a record. One of the fields is an image and I want to display this on the page.
My question is this: Is it possible to use the Binary write command i.e. Binary.Write("MyDatabaseField") on the same page that I want the image displayed on?
If not Is there a way to nest it inside an image tag as follows:
Response.Write("<img src=" & binaryWrite("mydatabasefield" & ">")
I have an asp page created in Dreamweaver with a form that is supposed to write to an Access database. It redirects to a formmail.asp that sends the info to my email. Everything works except the fact that no new info is written/inserted into the database.
I can connect, read, etc, it just doesn't write anything new. I get the email just like I'm supposed to only it has old entries and nothing new. There's nothing new added to the database when I check it. I've tried about everything I can think of. I've checked and double checked that the file can be written to, added all the default users, etc. Moved the file around, recreated the database, etc. I'm using DW 8, Access 2003 and Windows Server 2003. Code:
Now i have this part of the code . below in the code i should not call Sp_Getattachment if the Id = 0
but sme how I am gettin an error if I insert the If statemnt.
This is the part of the code:
I have a specific access db field that holds visitor website url's and I am currently displaying it onto a page as text but instead I need it to be displayed a clickable hyperlink.
The field datatype within access is set to url but when the entry is written to an asp page it doesn't bring the hyperlink properties with it.
I think I should be enclosing the RS within an <a href=''></a> type tag but can't seem to get it right.
Current code: Response.Write RS ("website") & "<BR><BR>"