ASP Query To Access DB & Remove Dups
I have a field called store, I have more than 1 row with the same store name in the store field.
I need to coolect all the stores from the store field, remove any duplicates, like I might have buy.com twice and only need it to show once in the drop down. And sort ascending (by store name).
Summary.
Database is called: tracker
The table (and the only table) is called merchants
I only want to pull data from the field store, remove duplicate store names, sort ascending.
I can figure out how to plug the required htm around the asp code, to auto populate the drop down.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Remove The Query Statement
I have this on top of my ASP response page: Code: SELECT * FROM bible WHERE text_data LIKE '%%' AND text_data LIKE '%%' AND text_data LIKE '%%' AND ( recordType = 'ju') How can I remove it?
Need To Convert This Sql Query For Access To Identical Sql Query For Sql 2005..
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.
Query Access With Multiple 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?
Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
Access Query
I'm trying to run an access query with one parameter that is a string. I can call a query that has no parameters. I can also call a query that has one parameter that is an integer. But the one that has a string parameter isn't working. Here is the code: [VBS]set rs = conn.execute("getArtists '" & ltr & "'")[/VBS] I've tried using a command object and it did the same thing. Is there any other way I can get my query to return the records. Running it in access works.
Run Access Query
I have a Acces query which creates a table using manipulated data from another table. I want my asp page to run this query after doing an update to the database.
Query / MySQL / Access
I've got a query that works fine when used in mySQL but completely fails when I try to apply it to MS Access, weird thing is that it is just a copy of a stored procedure that works fine in the same copy (with the Request.QueryString replaced by a fixed value) ! Any explaination would be great, ID is a number BTW : SELECT page_title,ID,page_content FROM content WHERE ID='" & Request.QueryString("ID") & "' ' Had a look at aspfaq.com but couldn't find anything that applys.
Reading Access Query
Is it possible to write an SQL statement that reads from an Access Query instead of an Access Table. If so is the syntax the same as for reading a Table.
Execute An Access Query
How can you use ASP code to execute an Access query. I want to run the query to then display updated data on the webpage.
Access Query Syntax
Where I found this? Like this: SELECT SELECT TOP N INTO FROM WHERE GROUP BY HAVING UNION (ALL) ORDER BY WITH OWNERACCESS ( http://msdn.microsoft.com/library/e.../access2sql.asp ) But with explanations (usage) and samples...
Limiting Results From An Access Query
I'm attempting to limit a query which is being ordered by a date field to 10 records. The date field contains duplicate values, which are sorted from most recent, back. However their suggestion of sorting by a secondary field is not providing acceptable results (it returns all the rows in the database). Does anyone have any suggestions of another way around this?
Online Query Analzyer For Access
What is the best way to create new queries and/or modify existing tables within an online access database. At the moment, I am periodically downloading the db and making alterations. But, I have heard others on the list say they use a query analayzer built on a <form> where they execute SQL statements. Is this the correct way to go?
Update Query Works In Access, Not In ASP
I have the following query: Update properties set Last_Change=#8-Mar-2006# Where properties.fdref='h3c000'; which works fine when I run it on my desktop under MS Access, but when I run it as an ASP page, I get the following error message: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. I am using the same database bot online and offline so field names etc are exactly the same.
ASP Search Using Query In Access Database
I have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias. NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in... Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
Can I Use A Query Stored In An MS Access Database From An ASP Page?
Currently, I do the following in my ASP pages when making use of an MS Access database: Dim adoCon, rsSet, strSQL Set AdoCon = server.CreateObject("ADODB.Connection") Set RsSet = Server.CreateObject("ADODB.RecordSet") adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("MyDB.mdb") strSQL="SELECT * FROM MyTable;" rsSet.Open strSQL, adoCon ...do some stuff... rsSet.Close adoCon.Close Set rsSet=Nothing Set adoCon=Nothing I have a couple queries stored in the database that I use when in MS Access. Can I call these queries instead of using a string to specify the SQL command? The above seems kind of verbose for making use of a database. Can it be simplified at all?
Asp Search Returns No Results From Access Query
here's what i want to do. from an asp page, perform a search on a table in access. i have used sql code in the asp page itself, but i'd rather execute a query in access. i have success in running any query (basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for some reason, when i execute the query below from the asp page, i get no results. the search.asp page just has a text box in a form that submits the srchBOX field to the results.asp page. here's the asp code from the results.asp page: Code:
SQL Query Not Returning Results In Access For Dates
I am trying to search through an access database for tickets createded with in a certin date. I am using the below code. strdate = DateAdd("d", -2, Now()) sqlstr="SELECT * FROM Incidents WHERE TicketDate BETWEEN #"& Now() &"# AND #"& strdate &"# ;" I verify the query with response.write and get the following. SELECT * FROM Incidents WHERE TicketDate BETWEEN #15/07/04 19:19:32# AND #13/07/04 19:19:32# ; I know there are 100% tickets within this date. Yet my query returns nuthing. Please help i've searched this forum for other peoples code looking for examples but end up with the same result.
ASP, Access & "Operation Must Use An Updateable Query"
Getting an error using ASP with an Access database on a remote host (I don't control perms). It's giving this error: Microsoft JET Database Engineerror '80004005'Operation must use an updateable query. /admin/projects.asp, line 180 Isn't this normally just a permissins error? The host says they've just given full permissions so it shouldn't a problem, but I want to confirm that this is a perms issue before I get too uppity. It happens on every INSERT/UPDATE/DELETE that is attempted to be run, and the exact same SQL statements work perfectly on the local machine and network, so my gut instinct is perms.
"OR" Access Query From ASP (via Checkbox)
The setup: Access database of vendors. A vendor can offer one or more services. ASP page provides user a checkbox of services. User clicks one or more options and submits. The database should return all vendors that match the services selected. No dice. I can of course easily pull up vendors that match one service. But the multiple options are treated as an AND search. I don't want to find only vendors that provide all the services checked, but all the vendors that provide one or more of the services selected by the user. I have tried stored procedures in Access and SQL statements. I either get data type errors or nothing found.
Need To Remove DAY Name
I found a simple date script, which is this: <% var_date=date() 'get the current date var_date=FormatDateTime(var_date,1) Response.Write(var_date) Wednesday, September 29, 2004 How can I get this to not display the day of the week, I only want - September 29, 2004
Remove DAY Name
I found a simple date script, which is this: <% var_date=date() 'get the current date var_date=FormatDateTime(var_date,1) Response.Write(var_date) %> Wednesday, September 29, 2004 How can I get this to not display the day of the week, I only want - September 29, 2004.
Remove Dot
i have a variable which holds a value like this stramount=Trim(Request.form("txtamount")) response.write stramount the output sometimes is 50.00 or 50 or 50. if it is 50. i want to remove the (dot) at the end. can someone tell me how to use the instr function to see if there is a dot at end and if it is there then remove it.
Remove The Gap
i have problem in removing the gap between two images, pls see the attached image. coz my item name is quite long, i dun wnat it display in horizontal, i want it display as vertical. so i create the images for the character and use ascii to recognized it. my code is as below: <td align="left" class="BorderLeft" width="1%"> <%dim word, pic, word1 word = "AAAAABABABBA" pic = "" for i = 0 to len(word)-1 word1 = cstr(right(left(word,len(word)-i),1)) pic = asc(word1) & ".gif"%> <img src="../images/<%=pic%>" border=1 vspace=0 hspace=0> <%next%> </td>
How To Remove Cookie?
How can I remove a cookie from the client in ASP? I'm not talking about setting the value to a blank string and I've tried this: [vbs] Response.Cookies("mycookie").Expires = Now() [/vbs] and [vbs] Response.Cookies("mycookie").Expires = Date() - 100 [/vbs] Neither of which work. Is there any way to completley remove the cookie?
Remove Header
can anyone temme the script or style sheet to remove the hearder and footer url address of the web page when printing the pag
How To Remove Duplicates
How to write asp code to remove duplicates in an array. For Eg: A()=(1,5,10,15,10,20,5) After removal of duplicates it should be A()=(1,5,10,15,20).
Add Remove Button
The main idea goes like this: I have a textarea, on the right I have a listbox whose elements are loaded from an Oracle Database, I want to have an "Add" Button which when pushed will insert in the textarea the value selected on the listbox between "{ }" (ej, The {white} cat), you can add as many values as you wish and also manually edit the text, and a Submit button which open another ASP page that will check the sintax of the textarea and insert it on the Database. So far I already have the part which checks the sintax and inserts it on the db, and the listbox with the elements you can insert on the textarea, but my boss really wants the "Add-Remove" feature and I need to finish this for Tuesday
Remove Underline
I have image icons that are clickable. I want to remove the hyperlink from around the image. I tried the STYLE="TEXT-DECORATION: NONE" tag but thats not working. How should I remove the underline from the hypelink. Code: strImage = "<A target=""_blank"" href=""document.asp?job=" strImage = strImage & jobid & "&doc=" & filename & """ STYLE="TEXT-DECORATION:NONE">" strImage = strImage & "<IMG SRC='" & GenerateIcon(rs("filename")) & "'/></A>"
Remove Left Of ,
Would search for this but forgot what its called? I wanna remove everything from the left of the camma in a variable: 43,7-3-05 to 7-3-05
Remove IMG Tag Toggle
I am wanting to create a large dynamic web site with an accessible Text Only version.Instead of creating additional pages for the text only version, is it possible to implement some regular expressions, which remove all the IMG tags from page. I have found a useful tool at http://tantek.com/favelets/ which removes the CSS from the page but I also need to remove the images.Are regular expressions the best means of doing this?
Remove Items
Response.Write "<TD>" & "<a href= objRS.Delete>Remove</a>" & "</TD></TR>" I have a basket which people add stuff to that they want to buy. i want a code that allows them to delete the item too. how the basket works is. thy choose a item from stock page and then it adds to a basket table.
Remove Duplicates
I have declared a multidimensional array as follows. dim parray(100,5). Now this array contains some duplicate values. So how to remove duplicate values in this multidimensional array.
Remove Commas From End Of String
Using ASP/VB I need to remove unwanted commas from the end of a field that will be use in an array. There are items in the field that are comma separated, so I don't want to remove them, just the end ones, could be anywhere up to 5 unwanted commas. Any ideas?
Remove Item From Cookies..
Is there a way to remove item from cookie collection that has a key to it... -- Response.cookies("items")("item1") = "111111" Response.cookies("items")("item2") = "222222" Response.cookies("items")("item3") = "333333" Is there a way I can remove items- item2 and rearrange above cookie into Response.cookies("items")("item1") = "111111" Response.cookies("items")("item2") = "222222"
Remove The Page.asp After The Link
How can I remove the page.asp link from the address bar? For example I have a link called www.mysite.com/page.asp?f=1, after the user clicks on the menu navigation. How can I get rid of page.asp?f=1 so that only www.mysite.com appears? Another thing, will request.querystring still work then?
Reg Exp To Remove Part Of String
how do I get a reg exp to remove part of a string? - I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
Import From Csv - Remove Commas
I'm importing data from a csv file but have the following problem. It see any comma in a specific column as the end of the current column and move the rest of the values into the next column I.E Data from column 4 display as data from column 5. I do know that it's comma delimited but would like to know if there's no way that I can distinguish between the commas in a column and the commas that indicate a new column. Col1 Col2 Col3 Col4 Col5 Value Value Value Val,ue Value How do they do it in excel?
Remove Stylesheet Effects
How can i remove the efects off a stylesheet ? I want to export to excel and dont want that the effects off style sheet come with.
Session.Contents.Remove
for each item in Session.Contents if NOT( Instr( item, "customer_" ) = 1 OR Instr( item, "user_" ) = 1 ) Then Session.Contents( item ) = "" Session.Contents.Remove( item ) end if next 'item response.redirect( "menu.asp" ) the code essentially - is supposed to - go through the session variables and remove every one that doesn't being with "user_" or "customer_". So when i try this out, it goes through and removes some, but not all of the session variables in question. run the script 3 more times and then they are all gone. So i inserted a bunch of response.write statements and found that not ALL of the session variables were even being tested. Can anyone offer explanations as to why?
Remove A Specific Item
I have a script which creates an array by doing this:Code: strInputValue = "this will be split into an array" arrMyArray = split(strInputValue) This produces an array of 6 (UBound(arrMyArray) = 6). Is it possible to remove part of the array, so that "into" for example will be removed, such that UBound(arrMyArray) = 5?
Remove Part Of String
Following java script code to get subscriber ID, its value is like 975683678-28_luxap01s.southernlinc.net, I want to leave number there and cut starting _ part, does anybody know how to remove the character starting underscore "_"? the final value is 975683678-28. <% subsciberID = Request.ServerVariables("HTTP_X_UP_SUBNO") ; %>
Remove Element From Array
is there a function i can use of some sort to remove a specific element in an array by its index number?
|
TRACKER
