Search results for query: *

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...

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...

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!

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...

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...

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?

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...

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...

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?

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")&"'")

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?

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(...

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...

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?

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...

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...

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") &"'

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...

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...

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...