If I have a search submit button, when I click submit button, it will submit
the form to search.asp for form processing.
This will be the URL: http://www.mycompany.com/search.asp?q=programming
But when I do search in google, search doesn't have any file extension. How
do they do that? I saw some site are like that too.
http://www.google.com/search?hl=en&...G=Google+Search
..asmx not getting parsed.whten I call a page with an .asmx extensionon my machine
all I get is the code, it does not get parsed.how can I fix this, can I manually add some ISAPI application to IIS to make it work.
How can I validate a file extension before it is being uploaded to the server?Let's say I want to check the last 3 or 4 chars of the file, if it is JPG. then upload it. If not, alert(Only JPG file allowed).I'm using this allow user to upload.
<form......>
<INPUT TYPE=FILE SIZE=102 NAME="attach1">
.....
</form>
I am trying to upload a file to the server but first I want to rename it to the users session id. Ok everything is working except when I rename it, it drops the file extension. What is the best way to get the previous file extension and add it to the new file name? Here is an example of what it is doing on my end.
filename: test.xls
rename: 123456678
what I need: 123456678.xls
I have a site that is HTML and I am considering moving it to ASP. However this site has a great deal of investement already on SEO and changing the extension on the files would take a hit to our rankings. I've heard that there is a way of saving the ASP files as HTML extension. Does anyone know how to do this?
View Replies View RelatedI got background in my left and right frames (tables) and on the background image there's a custom border on each side. I want the background to extend on a different resolution rather than repeat. Anyone know how I can pull this off?
View Replies View RelatedWhen I create an asp file and click on it on my local drive, photoshop opens it, because the asp extension is already defined to photoshop.
I know you can try to change that extension association in the windows folders options, but even though photoshop owns the extension, it does not appear in the list of extensions. Is there some way to get photoshop to let go of the extension?
I used to have a dreamweaver extension, which inserted the asp script for recordset paging, you know the one where at the bottom of the page there is a line of links allowing you to search through your recordsets without having to load them all in. Anyway I formatted my hard drive and thought i had saved it but i turns out i didn't and cannot find where i got it from.
If anyone has a dreamweaver mx extention for this can you please upload it as an attached file so i can download it.
i want to hide my ASP page extention in IE AND NE address bar how can i do this pls tell me about that.
View Replies View RelatedIf I want to know if a file exist. But I do not know it's extension, how shall I check the extension and if it exists? (I know the name which to check)
View Replies View RelatedIf you'll notice, there's a comment in this snippet that drops the extension. How can this be modified so that the extension IS shown?
Set myFileSys = Server.CreateObject("Scripting.FileSystemObject")
Set Folder = myFileSys.GetFolder(Server.MapPath("/meetings"))
for each file in Folder.Files
If Not file.name = "index.asp" Then
FileName = Left(file.name, (Len(file.name) - 4)) 'drop the extension
FileSize = cint(file.size / 1024) 'convert into kilobytes and drop the decimal
Response.Write("<li><a href='/meetings/" & file.name & "'>" & FileName & "</a> - " & FileSize & " K<br>" & chr(13))
End If
next
Set myFileSys = nothing
i want to hide my ASP page extention in IE AND NE address bar how can i do this pls tell me about that.
View Replies View RelatedIs there a string function to strip the file extension from a variable in ASP? If not any suggestions as to the best way to approach this?
View Replies View RelatedI have a website in ASP. Is it possible to somehow hide the .asp extenstion, so that other don't know what backend language is being used?
View Replies View RelatedSometimes I have seen the URL doesn't have the file extension, like the following:
http://server/signup?id=1001
rather than
http://server/signup.asp?id=1001
anyone knows how to do that?
where can i find the ASP file upload dreamweaver extension for free? if not, would someone suggest a way to upload file into database using dreamweaver?
View Replies View RelatedBasically I want to parse an XML feed - the problem being the XML data itself has a .asp extension and a few query strings.
I can currently parse the same xml data if I save it with a .xml extension, just not with the .asp extension and query strings. Code:
I'm having problems with one of the websites on my MS2000 server. I can't publish a fp2000 web to it properly because it thinks fp server extensions are not installed.
Whenever I use the MMC snap in to check the server extensions for this web, it tells me that my admin tool is not compatible with installed server extensions. Not sure what to do with this.
How verify type or extension of file using ASPUPLOAD? I check documentation, but I didn't find anything else yet.
View Replies View RelatedMy 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.
I have an upload feature on my site... it works fine... but I want to validate the uploading file extension for .doc or .html before being uploaded to the server(client-side).
I have the validation to check text fields are not blank.... The first validation is for checking the text field... the second "blob" is the file upload field.... This is my code in Vbscript.. Code:
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).
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?
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:
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..
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.
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.
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
I have an Access database of literature that I want to search using an ASP page using multiple search criteria (author, title, year, discipline,etc).
I'm using a form to collect the criteria from the user and then sending it to an ASP page. I'm creating the SQL statement using variables that pick up values passed from the form.
Code:
strSQL = "SELECT * FROM Literature WHERE " & _
"(Author Like '%" & mauthor & "%') AND " & _
"(Title Like '%" & mtitle & "%') AND " & _
"(Journal Like '%" & mjournal & "%') AND "& _
"(ArticleBook Like '%" & mBookOption & "%') AND " & _
"(Year Like '%" & myear & "%') " & _
"ORDER BY Title ASC;"
This would probably work if I used "OR" in my SQL, but I want to be able to use "AND." My problem is that I'm not getting records that have null values in some of these fields.
Ive been working with queries through asp on a mdb file. The biggest problem i have is
that when i query a certian column that had embedded hyperlinks in it, the query also
returns the value of the hyperlink. Is there any way not to have to remove the hyperlinks
in the database and not have them show up on queries? Code:
I am learning ASP from the Wrox Begining E-Commerce book, which uses Visual Basic to create a DLL and it also uses MTS as well.
I have been trying to find hosting not realising the problem with registering custom dll's on server and know realise that this isn't the best way to do this.
I wanted to know if there was anything i could do to change this. I have read a little bit about the Global.isa file but am not sure about this.
Could i just transfer all the code into the global.isa and then use it like this.
My website access a sql database and uses a mts pipeline for order processing.
I don't have enough experience of ASP to re-write this code and am not sure of what to do.
I have tried searching the web but am not really finding any solutions that I understand.
I have one table with date field in sql server2000.I want to write one sql query statement that fetch last three months data from the current month..
View Replies View RelatedI am trying to have the SQL query select from a table where two conditions exist.
The line:
Code:
SQL = "SELECT * FROM CompsIn WHERE Out = -1 "
Works, but I want to have it also select from compsin where UserGroup = Session("UserGroup")
Until I connect the login and the CompsOut pages,adding Where UserGroup='CSU836'
will work just fine.