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!

  • Congratulations strongm 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: SebFr
  • Order by date
  1. SebFr

    Merge with an UNION

    Thanks Leslie. Exactly what I wanted.
  2. SebFr

    Merge with an UNION

    Hi, I've two separated queries that both return two columns: the first one returns NAMES | #ORDERS, and the second one NAMES | #SALES I would like to merge those two queries to one query with the columns like that: NAME | #ORDERS | #SALES. I tried to add the missing column on each query with a...
  3. SebFr

    WebBrowser - DownloadComplete

    Hi, I'm working on an application in Microsoft Visual C# with an embedded webbrowser. After I loaded a page, I'm using the event DownloadComplete to execute an action. On my computer it works fine, but in some other computers, the event DownloadComplete is never reached, even if the page is...
  4. SebFr

    Calling a javascript function from C#

    Hi, I want to be able to call a JavaScript file from a C# Windows application. This is just a stand alone C# application. What I want to be able to do is to execute this JavaScript file, think of it as a function, and be able to pass parameters into it and to receive a return result from it...
  5. SebFr

    axWebBrowser DocumentComplete

    Hi everyone, I have an issue with axWebBrowser. The method axWebBrowser1_DocumentComplete is never reached and i don't understand why. Basically, this is what I have: private void buttonStart_Click(object sender, EventArgs e) { try { ... axWebBrowser1.Navigate("http...")...
  6. SebFr

    Query: Double quote or apostrophe ??

    Thank you ! I don't understand why i didn't think about it earlier ! :/
  7. SebFr

    Query: Double quote or apostrophe ??

    I can't replace with 2 apostrophes, nameCompany is a variable. I recover this name from another database, I can't change it.
  8. SebFr

    Query: Double quote or apostrophe ??

    Hi, I'm executing the following query on a SQL Server 2005 database via a vb.net application: "SELECT FullName, Email, State, Country, Phone, Fax " & _ "FROM Customers " & _ "WHERE company LIKE '" & nameCompany & "%'" nameCompany is a variable in my program. My problem is that sometimes the...
  9. SebFr

    Convert datatype Memo to datatype Text

    Thank you PHV for your answer, it works now with the second solution you gave me !
  10. SebFr

    Convert datatype Memo to datatype Text

    Hi, I'm using Access 2003 and I'm having a query problem (again) with a linked table in SQL Server 2005. Query: SELECT Left([Comments],2) AS CSR, Sum(Orders.FinalGrandTotal) AS GrandTotal FROM Orders GROUP BY Left([Comments],2); 'Orders' is a linked table in SQL Server 2005, and 'Comments' is...
  11. SebFr

    ODBC Call failed 'cause of a Group By?

    Thanks for your answer bborissov ! "Answering Service" is a string constant, and i've changed my request as you wrote it but I still have the same error...:(
  12. SebFr

    ODBC Call failed 'cause of a Group By?

    Hi, I'm using Access 2003 and I'm having a query problem with a linked table in SQL Server 2005. Here is my query 1: SELECT "Answering Service" AS Name, Count([CSR00 - IP Addresses].GrandTotal) AS Orders, Sum([CSR00 - IP Addresses].GrandTotal) AS [Total Sales] FROM [CSR00 - IP Addresses]...

Part and Inventory Search

Back
Top