in my drop down dont want to show country names like United States and Canada but its still showing Code:
nusa="United States"
ncanada="Canada"
Set rs = Server.CreateObject("adodb.RecordSet")
strcountry="SELECT * from tblCountries where CountryName Not In ('"& nusa & "," & ncanada & "')"
rs.Open strcountry,cardconn, 2, 2
is the syntax ok
how i can tell . for exmple .my for malaysia,.id for indonesia and how i want to know for all country in the world.. hope u understnd for interrupt.
View Replies View RelatedFor web trends, i need to display country name with the help of IP. How can i do this with out any dll registering or installations in ASP?
View Replies View RelatedDoes anybody know how to determine a user's country or LCID in an asp page?
I've found some articles on using:
Request.ServerVariables("HTTP_ACCEPT_LANGUAGE")
but somehow this doesn't seem like a foolproof method to me.
How i can know the country of the visitor of the web?
View Replies View RelatedHow can i obtain Clients Country
View Replies View Relatedwhat is the easiest way to get the clients country, wthout asking them for it is there a HTTP request?
View Replies View RelatedI am trying to set page content to reflect where the user may come from.
Is there a fairly simple way to tell where web page requests are coming
from? (Site is on a Win2003 server)
i.e. something like (I know it not real)
<%If Request.ServerVariable(".HTTP_USER_ COUNTRY")="UK" Then %> ...
Does anyone know of a good ASP script that does the following:user selects country/regionredirects to page/site based on selectionremembers this preference for future visits.
View Replies View RelatedIs it possible using ASP to detect the country that a visitor to your site is in?If so, could you please point me in the direction of a site which tells you how it is done?
View Replies View RelatedHow do you know that a certain IP add is from a certain country? Can asp do this?
View Replies View Relatedhow I can check what country the user is visiting from? I know how to check the browser type etc. but not where the person visiting my site is actually resident. I'd like to know how to check this both in ASP and Javascript if possible.
View Replies View RelatedI've been to a few websites where it displays the town, state (if USA),
country I'm browsing from. Now, I know that detecting country is easy, but
how do you determine the town?
What ASP components do this?
Does anyone have some sample code on how to get all tables names in a MS Access database?
View Replies View RelatedI need the names of some either ASP or PHP programs that will work like a video rental store. I know there are some out there, but i cant seem to remember the name of them. I would prefer something that is free.
View Replies View RelatedDoes any one know how many characters possible in a variable name in ASP?
Is it only 15 characters long or could it be more?
i.e. could the variable name be ThisIsTheFirstName
I do not name my variables like this but I would like to know the max length possible.
I have a web application which saves files to a server and emails the file as an attachment. I generate a unique name for each file by concatenating a unique numeric string so the file name is unique and cannot be accidentally be overwritten. I also store the original name of the file. Is there any way to rename the attachment when I send it so it doesn't have the unique name but rather the orignal one.
View Replies View Relatedim reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
View Replies View RelatedIs it possible with ASP to use arrays with names (e.g user("username") = "ble") instead of numbers (e.g user(1) = "ble")?(I do know of the dictionary object, but is it wise to use that 7 times or more a page?
View Replies View Relatedive got a small problem, i dont know if this is possible but its bound to be. What im trying to do is request a cookie which contains a database table name and put that inside an sql query...sort of like this
id = request.cookies("tablename")
mySQL = "SELECT * FROM &'id'&"
i know that doesnt work, ive tried every other combination .
I am planning my next move on my current website and am looking at doing the following. I am adding a feature where as a database can be viewed on the web page as this has been requested for me to do.
I am pretty sure i can do this without a problem except for getting all of the table names. Is there an SQLQ command where you can say
SELECT (ALL TABLE NAMES) FROM DATABASE.
Antoher way to look at it is to have a seperate table in each of the databases to hold all of the table names.
a script that will automatically pull the names and custom preview icons of image files from a folder and display them on a page? is this possible? i need to use this script on a win 2000 server.
View Replies View RelatedI have two temporary variables that are equal to folder paths. The first temporary variable could equal one folder name or multiple folder names depending upon an if statement so "" & fldr1 & "" & folder.name & "" will not work.
Is it possible to combine both into a third temporary variable? Example:
TempPath1 = "" & fldr1 & ""
TempPath2 = "" & folder.name & ""
FullTempPath = TempPath1 & TempPath2
FullPath = fso.GetFolder(Server.MapPath(FullTempPath))
We have a script the will grab names from a form and display them on the next page but will only get a max of 60 to 80 names depending on the total number of characters of each name.
Can anyone guide us on how to create a script, where if a user copies and pastes 5000 names or email addresses into a form and clicks submit, we can then grab each name and display individually on the next page?
Does anyone know of a script or library that provides a way to match first names with common nicknames or shortened forms?
I'm developing criteria to determine whether two database entries represent the same person, and I definitely want people named 'Bill' and 'William' to score as having the same first name, for example.
Is it possible to get a db's column names not the data inside the columns just the columns names.
View Replies View Relatedi want to make a drop down menu with the names of the tables in the mdb. how do i get this right? do i use a sql statement? i cannot find a sql statement with the command for this.
View Replies View RelatedI 'd like to print out all posted parameter names and values. I'm able to print all the posted request values, but not the parameter names.
I am new to ASP and I cannot figure out how to pass variable content in ASP. How to pass the variable sClientNo in the following redirect.
Response.Redirect("AccessDenied.asp?ClientNo=sClientNo")
I have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?
View Replies View RelatedI have built input fields inside a while not.eof loop
and the name is built from using <%="name"&i%> and the value is a product_id
from the database.the i is then incremented in the loop, resulting in <input name="name1, <input name="name2
and so on. this works no probs, however i haven't got a clue on how to collect this dynaimcally named
input field when it arrives at the form action address page.
I was thinking some kind of for loop but am not sure, and again am not sure where to put the <%="name"&i%> bit
to count or grab the input fields info.
i.e newname= REquest.Form(<%="name"&i%>)
I have a "csv file" as a database.
The 1st row contains the field names:
Orion.Accounts.AccountName,Orion.Accounts.Address1
the code I use normally works:
<%=rs("Orion.Accounts.AccountName")%>
Although in this case is doesn't because the fieldnames contain full stops.
how to modify this line:
<%=rs("Orion.Accounts.AccountName")%>
I have a dynamic form sending information via name=value pairs.I know I can read the value of each element in the sending form by using the following....
for i = 1 to request.form.count
response.write "<p>" & request.form(i)
next
but since it's a dynamic entry page (it's built based on number of fields in a database), I need to know the name of each element also.not just the value.Is there a good way to get the "name" portion of the element on the form without having to parse through the request.form string?