Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aonefun
  • Content: Threads
  • Order by date
  1. aonefun

    returning distinct values for database field

    How do I set this query to return only distinct values for DocumentHeaders.SoldToFax? (I thought this is accomplished by the GROUP BY function). SELECT DocumentHeaders.SoldToFax, Min(DocumentHeaders.SoldToCompany) AS MSoldToCompany, Min(DocumentHeaders.DataSource) AS MinOfDataSource...
  2. aonefun

    group by function to eliminate duplicates in union query

    How would I alter the following code so that the Group By function eliminates duplicates from the DocumentHeaders.SoldToFax and DocumentHeaders.ShipToFax fields combined (as a result of the UNION query)(In other words, when the UNION query combines all fax numbers from both the SoldTo and ShipTo...
  3. aonefun

    remove extra space in the middle of a text field

    How do I remove extra space in the middle of a text field. There is not supposed to be any spaces in this field. Please provide specifics. Thanks!
  4. aonefun

    format fax numbers in query field

    I have created a union query of two tables that list fax numbers in a text field (notice that I don't have authority to change this field format to numeric) The resulting query has some fax numbers formatted in 2 different ways: (123)456-7890 and 123-456-7890 How to I change the resulting...
  5. aonefun

    table field's value based on value of another field same table

    I would like to set the value of an Access database table field to "Yes" if another field in the same record (of the same table) contains the value "invoice". Can I insert If statements into the SQL table view? If yes, what is the proper syntax to achieve this result? If not, what is the...
  6. aonefun

    designating webpage region to be sent as the TextBody of an email

    I have a web search application. I would like to be able to send the search results as the body of a text email. When sending e-mail with CDOSYS, how do I specify the region of the webpage that I would like to be sent in the TextBody?
  7. aonefun

    sql distinct

    While DISTINCT will bring results of only one record per SoldToCMAcountNo from the first query listed below, it has no effect from the second query as there are more than one field specified in the SELECT statement. >How Do I alter the second query so that there is only one record per...
  8. aonefun

    proper code syntax for dynamically switching sql recordset query

    Each of the following recordsets work as intended when used individually, however, I would like to switch between the two based on if Request.QueryString("PostalCode")has or does not have a value. I'm not sure if the proper code would include the IsNull or IsEmpy but when tried either one (see...
  9. aonefun

    response.write a recordset result

    I am aware that for troubleshooting purposes I can response.write a recordset result to see real time results based on current parameter values. Where do I place this response.write code in relation to the recordset code?
  10. aonefun

    proper syntax for multiple parameters sent as querystring

    Is this the proper syntax for passing on more than one querystring parameter? and if not, what is the proper syntax?: Response.Redirect("results_postcode.asp?PostalCode='"&Request.Form("PostalCode")&"'"&VendorPartNumber='"&Request.Form("VendorPartNumber")&"'")
  11. aonefun

    how to refer to an empty session variable

    I would like to show some code based on if a session variable contains a value. How do I put this into code: Is this the right way?: If session("postalcode")<>"" Then or do I use something like NOT ISNULL or NOT ISEMPTY?
  12. aonefun

    hide part of asp code if session is null

    I would like to have the following code show only if Session("PostalCode") is not null. I suppose I should put it into an If statement? I tried it as follows but it does nothing: If Session("PostalCode")<>"" Then WADbSearch1_whereClause=BuildFilterString("LATITUDE","" & cStr(...
  13. aonefun

    sql distinct

    Can I use DISTINCT in the following query that involves more than one field. I tried puting it in after SELECT and it still gave me multiple SoldToCMAccountNo SELECT , ID, DocStatus, CustomText10, CustomText07, CustomText08, ShipToCompany, ShipToContact, ShipToAddress1, ShipToAddress2...
  14. aonefun

    general question about session variable usage

    From experience I've learned that I cannot base one recordset on a recordset created on the same page? Is this true with session variables as well? Can I base a recordset on a session variable that was created on the same page?
  15. aonefun

    finishing SQL Query using OR operator

    Here is the first portion of my query which works fine: SELECT ManufacturerPartNumber, ProductFamily FROM Products WHERE ManufacturerPartNumber = Request.Form("ManufacturerPartNumber") However, I need to add an OR operator to include additional ManufacturerPartNumbers that share a common...
  16. aonefun

    hide session variable if recordset is

    I am creating a Session variable in my code as follows: Session("VendorPartNumber") = (Recordset1.Fields.Item("ManufacturerPartNumber").Value) I receive this error message: "Requested operation requires a current record" when ManufacturerPartNumber is empty. Is there an IF statement that I...
  17. aonefun

    syntax error in query expression

    What may be the cause of the error message: syntax error in query expression 'ManufacturerPartNumber="'? This is recordset query: SELECT Products.ManufacturerPartNumber, Products.ProductFamily FROM Products WHERE ManufacturerPartNumbe ='" & Request.Form("VendorPartNumber") &"'
  18. aonefun

    sql query to add records that share a common productfamilyid

    Some products in my database named "ManufacturerPartNumber" are part of a product family, thus they share a common "ProductFamilyID". How do I include these additional "ManufacturerPartNumber" fields that share a common ProductFamilyID in the query as follows: SELECT ManufacturerPartNumber...
  19. aonefun

    large database file size as a result of table addition

    I have added a table to my database that is causing the database size to grow tremendously. There are a total of 807,000 records of zip codes along with corresponding latitude, longitude, city and state names. I have set Unicode Compression to YES by all text fields. What other settings or...
  20. aonefun

    understanding recordset WHERE clause that alludes to asp page variable

    I have a fully functioning "store locator" web application that returns store location results based on a postal code form field. I am taking this existing application and would like to filter the results using additional search criteria. To accomplish this, I am incorporating this application...

Part and Inventory Search

Back
Top