Create IN Query
Our users want to be able to copy and paste some numbers in a box which on Submit will display the corresponding status of those records. So for example a person A will paste in the box
1234
4567
43322
4353
56
2454
242
and on Submit we are palnning to build a select query ( select id,status from table where id in ( '1234' ,'4567' ,'43322' ,'4353'...) and display the output. Kindly suggest on how to proceed with this. Would appreciate it if you can provide the code for this as we are not good at classic ASP.( not at programming.
View Replies
ADVERTISEMENT
In the same way that you can create and alter permanent tables in Access 2000 using SQL in ASP ( CREATE TABLE <tablename> col_1(col_1 datatype), col_2(col_2 datatype....Col_n(col_n datatype)) is there any way to do this for Queries?
View Replies
View Related
I'm using odbc and Classic ASP and I want to read the sql content of a query in an access database. ANyone have any clues?
View Replies
View Related
Here's what my code looks like...
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 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 there anyway to generate a PDF using ASP Scripting(VB Script).
View Replies
View Related
Does anybody knows a way (free of cost, code or dll) to generate pdf?
View Replies
View Related
I use a website in asp for which I have to type a username and
password everytime I want to login.
On the form are two fields for typing the username and password and
one button LOGIN.
I want to create an standard url for the website which includes my
username and password so I don't have to type it in everytime.
I looked at the page source but I can't find the right string.
I thought maybe http://.........aspx?username=me&password=it
but that doesn't work.
View Replies
View Related
Is there a (simple) way to create a PDF file from ASP?
View Replies
View Related
I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project.Visual Studo create the project but not the initial files and freezes.
But I may create a new project from Machine A using the web server of machine B.I have checked the access rights of both servers, the access rights on directory wwwroot and inetpub.Everything seems the same.
View Replies
View Related
Has anyone seen or know if anyone has done this? I think that ASP would be a great tool to do this with but I am curious if anyone has tried it and found it to be too hard or too burdensome to follow through with?
View Replies
View Related
I'm running IIS5 on a Win2K server, and I want to have an ASP page that
creates new users. I have some simple code to test this, but am getting
a "500" error when I run it. The ASP looks like:
<%
strDomain ="Foo.com"
strUser ="Foo1"
' Create new user with password
Set oDomain = GetObject("WinNT://" & strDomain)
Set oUser = oDomain.Create ("User", strUser)
oUser.SetPassword = "password"
oUser.SetInfo
%>
Just for this testing, I've added IUSR_machinename to the Administrators
group, but am still getting the 500 error.
View Replies
View Related
how to create dao.tabledef object in asp:
I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field
Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld
View Replies
View Related
Is there a way to create a host header in IIS with an ASP?
View Replies
View Related
I want to create a web page for my friends.(I have a subdomain and my server supports ASP scripts) It will contain a small basic guestbook.It must write the entries to a text file on the server.And i must be able to view the guestbook.
View Replies
View Related
I'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
View Replies
View Related
I am trying to create a menu with multiple tiers. I want to use the one menu as an include file throughout the site. Depending on what page you are on, I want the 2nd and third tiers to show up.
The rest just show the tier 1 links. I'm pretty sure this can be done in CSS, but the problem is that with a very big menu, I'd rather not have to load up the entire menu when it all won't be showing.
There for I figured I could create it in ASP. I could set some sort of parameter in the page so the menu include file would know what page I'm on, and then would only show and load the 2nd and 3rd tiers of that section. Is this possible? Code:
View Replies
View Related
is it possible to create a xml file and save so that i can upload with asp?
View Replies
View Related
i want to create flowchart/flowdiagram like msword.And the user type inside the rectangular what they want to do..
View Replies
View Related
How can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
View Replies
View Related
I have created an asp page that pulls data from SQL server and displays
on webpage in the form of Table and Chart.
I use OWC to generate Chart. It work find on my computer with Ms office
2000 installed, but when I upload my the page to my webserver, it
doesn't work with the following error message:
006~ASP 0177~Server.CreateObject Failed~Invalid ProgID. For additional
information specific to this message please visit the Microsoft Online
Support site located at: http://www.microsoft.com/contentredirect.asp.
Does anyone know how to solve this problem?
P.S. On the production server, Office Web Component had already been
installed. WSCript.CreateObject("OWC.Chart") works fine in my colleage's
vbscript file.
View Replies
View Related
tell me with some examples to how to use our own threads in asp pages. I tried to do it in usual way how we are suppose to use it in console and windows application. but the same thing will fail in asp pages. it give "nullreference" exception from unknown module.
View Replies
View Related
how can i create a new folder by using ASP??
View Replies
View Related
I have Windows 2000 and recently included Internet Information Services. I
then created a simple ASP file and clicked on it. The Open With dialog
appears asking me to select a program. I copied an existing ASP file,
test.ASP from another computer where it runs successfully. When I copied it
to my computer it changed to test.ASP auto file. The other computer runs
Windows XP. I am not sure is this is the issue. I verified the IIS is up
and running on my computer. Is there anything that can be done to correct
this?
View Replies
View Related
I am using ASP code to create a Word document on the server and all is working except for one thing: I need to be able to insert page breaks. My existing style formatting for page breaks does not seem to insert a page break into the Word DOC. Suggestions? Code:
View Replies
View Related
How to create a jobsite.Please help me.Is any information regarding how to proceed to create a jobsite
View Replies
View Related
I've captured some data from a form and stored it in an SQL server table. The form is passed to an action script which builds the sql statement and writes the data to the db.
I want to write a URL (http://www.mysite.com/sites/home.asp)
and store the userID at the end of the URL (http://www.mysite.com/sites/home.asp?userID=22) so when I call the URL from a web page it goes to that users page.
I'm not sure how to approach this?
View Replies
View Related
I know I can Create Tables In a database with the CREATE TABLE sql statment, but I don't exactly know the syntax of the statment.
I want to add a table with a sertin feild that has a default value, is that possible?
The syntax I know is:
sql = "CREATE TABLE tablename(feildname FEILDTYPE,feildname FEILDTYPE...)"
Are there any other parameters that I can add to the statment?
View Replies
View Related
I would like to create a login into my very simple web site. I was hoping if somebody could give me some links for good websites or if somebody has a good example that i can work on. I also want to be able to allow users to join.
View Replies
View Related
I want to take a text box that is in a grid and make it a combo box: Here is what the first part of the HTML looks like now:
<input type="text" name="txt_SERVICE_SN"
onkeypress="filterNonNumeric()" size="5" maxlength="3"
style="text-align:right"
onchange="fieldEdited(this.parentNode.parentNode)">
I tried switching the "text" to be "combobox" and that doesn't work.
I saw some other code for other combo boxes (not in the grid) and saw something like this:
<select id="test2"></select>
This will make a combo box. But I don't know why. I can't see anything in there that uniquely identifies this as a combo box.
View Replies
View Related
