Defined Query
Here's what I want to do.I've displayed records from the Db to a page called Inns.asp.
Among those records are COUNTY, CITY, STATE, ZIPCODE.
I created four asp pages called CountyInns, CityInns, StateInns, and ZipcodeInns.
They all display respective records with links to a redirect page. That's where I get stuck.If I have 50 records, say, displayed, i.e., COUNTY, how can I run a script against all the possible counties, without having to write a script for each and every city within that county?I do things somewhat differently, because this stuff is too tricky for me. It doesn't come easy but I usually get it right after a lot of help and attention. I bet there are other ways to do this but i'm not sure I can learn it any other way than the way I do it. Inns goes to CountyInns which leads to CountyInnsRedirect which (hopefully)contains a script for individual County display.
View Replies
ADVERTISEMENT
I am processing a form and I want to double check that a field is defined so that no error occurs. How do I check if a key exists in a collection (the Request.Form collection)?I do not want to process all of the fields in the form, so I do not want to use "For Each x In Request.Form". I process a certain list of fields and just in case the field was left out, I want to prevent an error from occurring from trying to use a key that does not exist.
Code:
For Each x In arrayFields 'arrayFields contains certain field names
'verify that field actually defined
If [field is a key in the Request.Form collection] Then
stringTemp = Request.Form(x)
'do stuff
End If
Next
View Replies
View Related
I'm having trouble with checking if a variable is defined. It is the conidtional statement of an IF statement.Ex.
IF var is defined then
action
else
action
ENDIF
View Replies
View Related
The site is for subscribers only. The frontpage is open to everyone, but when one clicks a link on the frontpage, the visitor is redirected to a login form. The code that processes the form checks the username and password. If they match, a session variable is set and the browser is forwarded to the link clicked in the first place.
Now, I want to make a addition: When a user that is not logged in clicks on a link on the frontpage, before the login form is shown, I want to compare the browser ip address to a list with subscriber ip addresses. If the browser ip is in that list, the login form should not be shown. Instead should the session variable be set and the browser forwarded to the article requested. Code:
View Replies
View Related
I have to Execute a User Defined function from ASP page and also the function returns a varchar. Could someone help me out with the code for this.
View Replies
View Related
I need someone to point me in the right direction. I would search, but I am not certain what I neen to search for. Here is what I want to do.
My Intranet homepage has four content-blocks of information. Each content-block has specific type of information (i.e. HR stuff or international stuff).
I'd like to add more of these content-blocks an give our employees the option of choosing which four they want to see.
Most portal technology offers this, such as My Yahoo. What kind of technology do I need to look into? Cookies? Are there any scripts that I can use to assist with this?
View Replies
View Related
This is my user-defined class
class ABC
public CC
end class
I make a instance of it and store it at the session
set ee=new ABC
ee.CC="hi"
set Session("myobject")=ee
But when i retrieve it and access the property of my
object, it said that The object does not support this
property or method, is that ASP cannot do this, or my
code has error?
set eee=Session("myobject")
response.write eee.cc
View Replies
View Related
I am looking to personalize my Intranet homepage were the user has the information they want on their page.
For example all their fav sites on the homepage, like the news headlines, email account already open for them, any suggestions of how to start or the best possible recources to use.
View Replies
View Related
I am using aspload to allow users to upload three files - 2 pics and a word
doc. The files have standard names but I want the user to define the name of
the folder.
Is there and efficient way to make sure that the user does not choose
illegal characters for folder names? I am doing a series of replaces at the
moment.
View Replies
View Related
I am trying to get the list of all user defined tables from the Access database. If I use the following query in Access it's working fine and getting the result. But if I am trying to execute the query in ASP page, it's not working. I am getting an error ([Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'.)
Can u please tell me the reason.
SELECT MSysObjects.Name AS TableName
FROM MSysObjects
WHERE (((MSysObjects.Type)=1)
AND ((MSysObjects.Flags)=0));
If you have anything, to extract user defined tables, please tell me. Either one works out for me.
View Replies
View Related
I'm getting the following compilation error on the line of vb.net code below. Compiler Error Message: BC30002: Type 'DirectoryEntry' is not defined. Dim dirEntry As new DirectoryEntry(strLDAPPath)
I have System.DirectoryServices added to the project references and to the aspx form. The autogenerated code includes "Imports System.DirectoryServices" in the source. Any idea what's need to get the compiler to see the reference?
View Replies
View Related
I have a pop-up window with a search button. If click on this button then a record list is made on this pop-up window. Each record have field with a href link. If you click on the href link next function is executed: Code:
View Replies
View Related
How does one create user-defined objects in ASP? Sorta like the response and request objects, where you can do response.write, etc.
I'd like to create my own object called Customer, so I could do Customer.firstName, Customer.lastName, customer.age, etc. I couldn't find any helpful info on this topic on the Internet or in my ASP books.
View Replies
View Related
I'm forced to use legacy ASP for a new project i am working on and seeing as how I never use ASP I needed a little help with something.
I need to create a function with optional parameters. I know in .Net I can use the "optional" keyword in the function definition to create optional parameters. can this be done in ASP 3?
View Replies
View Related
I have a project where I want an email to be sent at a certain time, say 10 PM every night if there are new hits to my site. The email will be only going to my email address. does any one know of a way to do this?
View Replies
View Related
I've read that one shouldn't include ADO objects in the Global.asa for the sake of performance, but would user-defined classes cause the same kind of performance hit? Assuming that they wouldn't, is it possible to do it?
I can't seem to figure out how to include them, nor find any reference to it in msdn.
Is there a way to do this? Or should I create a slew of Session variables? Code:
View Replies
View Related
if I have some system defined variable in my table column, say I am using a column called Default which is bit type. Its enclosed in square braces like this [Default]. Whenever I try to modify a record, it returns the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Default'.
/performaindia/maint/logtype.asp, line 170
in line 170 its
rs.Update
Any hints where to make the changes.
View Replies
View Related
I use the following code in developing a web application with ASP. But after viewing in browser, it told me "Error: 'WScript' hasn't been defined".
the following code:
<script language="JScript" >
function funGetSleep()
{
//to sleep 1 min
WScript.Sleep(60000);
alert("it is ok");
}
</script> .
View Replies
View Related
for debugging purposes, I am wondering if it is possible to have an ASP script that:
-creates a tabel with two columns
-writes a var name in the first column
-writes its value in the second column
is this possible? Right now, I have manually created this tabel for myself, but everytime a new var is defined, I have to update my 'debug' table. Can this be automated?
View Replies
View Related
How to get/set and send the HTTP Headers(user-defined) coming from another domain/site]
In one SMS gateway project i need a great and urgent help from u all. There,the Service Providers sending the data thru "HTTP Headers" (For ex.sms-Id,sms-source [user defined]).
So i need to get and parse the name value pairs, and need to respond/send the same way as coining the "HTTP Headers" (For ex. sms-Id,sms-destination,sms-msg [user defined]).
View Replies
View Related
How can I give a user-defined object session scope? From
http://www.microsoft.com/windows200...asp/iiwaobu.htm
I gather that it can be done, but there are no examples. Simply setting
Set Session("tag") = new MyClass
doesn't work.
View Replies
View Related
ok - this works:
Dim X
X = CreateObject("Scripting.Dictionary")
X.add 1, "Hello"
This doesn't....
Dim X
X = CreateObject("Scripting.Dictionary")
Class Aprivate VEnd Class
Dim B
B = new A
X.add 1, B
Can anyone tell me how to make this work?
View Replies
View Related
I have 2 web servers both running win server 2003 with iis 6.0. On my
PROD server I have a virtual directory called CONV. It points to a
folder on the C drive of this PROD server.
On my TEST server, I defined a virtual directory called CONV. It points
to a share called prodservernameCONV. Note that the share name is
the same name as that of the virtual directory.
Using IIS on the TEST server, I can navigate to this CONV virtual
directory and via right mouse, click EXPLORE. I see all the content I
should but when I try to doubleclick on a file I get a message saying
"Security alert" - "your current security settings do not allow you to
perform system commands on this item".
I've tried everything I can think of on the security settings for the
physical folder on the PROD server. I extended EVERYONE from READ, etc.
to FULL CONTROL. I added the user called INTERACTIVE and gave it full
control. In short, I am stumped and guessing now.
Basically, I just want to avoid duplicating all the data files on my
PROD server over to my TEST server.
View Replies
View Related
i have this.asp page:
<script type="text/vbscript">
Function myFunc(val1ok, val2ok)
' do something ok
myFunc = " return something ok"
End Function
</script>
<html>
<body>
<%
val1ok = something1
val2ok = something2
thenewVal = myFunc((val1ok), (val2ok))
%>
</body>
</html>
i want to call and use the returned value of Function myFunc(val1ok,
val2ok) ,without omitting the html script tags and replacing them in <% %>,
(My Question is:) How do i call a function defined in html script tags from asp page?
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
i m getting this following error:
Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
Following is my code: ...
View Replies
View Related
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
View Replies
View Related
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
View Replies
View Related
In Access you use "*" + [passed variable] + "*", + can be replaced with &
Calling a parameterized query in Access requires % be used in place of *,
however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get
matches at the end, not throughout the column. Code:
View Replies
View Related
Is it possible to write sql query to fetch records from
specific record number?
lets say i have one variable and it stores values such as
1,2,3 or so...
if variable contains, i want to fetch records from 1 to
20.
if it contains 2, then records should be from 21 to 40.
for 3, records would be 41 to 60...
what could be the sql for that?
i dont wannna fetch whole table and then filtering
through code..
View Replies
View Related
i have a table called checkrenewal
it has a field called date_renewal
data is stored like this
03/20/2007
05/17/2008
10/21/2006
09/18/2006
09/04/2006
so what i want to do is display only records that are in month of sept for 2006
so there will be 2 records
so next month is Oct 2006 so only display one record
so depending on which month and which year it is display only those records.
View Replies
View Related
I can't write the sum of a certain colum in a table of a db.
<%
sql_Sum_Tax="SELECT SUM(vtax) AS sql_Sum_Tax_RS_Var FROM orderstats
WHERE vcompletedate BETWEEN "& startDate &" AND "& endDate & ";"
Set sql_Sum_Tax_RS = Server.CreateObject("ADODB.Recordset")
sql_Sum_Tax_RS.Open sql_Sum_Tax, conn1
%>
<%=sql_Orders_Placed_RS("sql_Orders_Placed_RS_Var")%>
That last line generates this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
View Replies
View Related
i have a table and the fields are
gender
weight
points
the records for example are
Male 55 2.0
Male 60 3.12
Male 65 3.87
Male 70 3.99
so i need to find out the points when the user selects gender and enters the weight
people are allowed to enter weights between 55 and 70
say for example someone enters weight as 55 his points will be 2.0
if someone enters weight as 64 i want the points to be 3.12
View Replies
View Related
