Search results for query: *

COOL!!!! Thanks to both of you!!!!! :) Styx

...now BUT I am wondering if I can do this effeciently in a single query? This code uses 2 SQL queries to accomplish this: strSQL = "SELECT COUNT(*) FROM tblTelDir WHERE TelNum = \"5555551212\""; objRs = objDB.Execute(strSQL); intNumOccurrances = objRs.Fields(0).Value; //get number of...

Hello Perl Mongers! Environment: libwww-perl: 5.805 Crypt::SSLeay -- 0.51 OS: Solaris 8 Perl: 5.8.4 Issue Summary: Issue with SSL POST operation. I have a script that randomly fails against devices using HTTPS example: I run the script 3 times aganst the same device and all works ok. Then the...

Actually my default value is: =Right(Year(Now()),2) & IIf(Month(Now())<10,"0" & Month(Now()),Month(Now())) & "-" I just simplified it for purposes of demostrating the main issue of the default value clearing on me. I'll play around using two text boxes. thx, styx

hmm, tried that but got no value in the ordnum field on a new rec. What I need is: click on new rec button Ordnum field should display [0603- ] then the user will enter a 3 digit seq number (such as 123) after the "-" giving the result: [0603-123]...that is the key value that should be stored...

...i am using a query joining two tables. SQL=SELECT tblOrders.ordnum, tblOrders.orddate, tblOrders.salesm, tblOrders.custnum, tblOrders.comments, tblCust.* FROM tblCust INNER JOIN tblOrders ON tblCust.custnum = tblOrders.custnum; Does anyone have any ideas why or how I can correct this? Thanks!!

Word 2000 - SP3 W2K O/S My doc was 733KB and contains some inserts of small gif photos. All of a sudden I opened the doc to make some text changes and I start getting the message "There is not enough memory or disk space to display or print the picture". I made a small text change and saved the...

PIX Console Port: To access the PIX console port with a dumb terminal, you need a DB9 null modem cable, CISCO part# LDW0398-72-0876-01. DB-9/F to RJ45 works too as long as its Null Modem pinned. Configure the dumb terminal for 9600/8/N/1 (flow control to hardware). Use can also use the serial...

can you post your config? #sh conf #sh run

cool, let me check some other knowledge bases on this issue and see whta i can find for you. K

You will not be able to see any Novell or IPX resources. Here are my engineering notes: Q: Can I map drives to Novell File Servers? A: No. The VPN system is based upon the TCP/IP protocol and not the IPX/SPX protocol used by Novell. Therefore, the VPN system cannot interact with Novell systems...

Hi Bob, The inventory-totals created a multi-record result. I have decided to re-write all the original queries and build a table with one record, then I will have the summary queries update the corresponding summary field in the table with one record. K

Resolved: PIX was globally Nating to old pix outside address. config chnges: global (outside) 1 interface nat (inside) 1 0.0.0.0 0.0.0.0

Yes, the GROUP BY Products.obsolete HAVING (((Products.obsolete)=False)); produces one record with the two summary totals. It just so happens in this database , since it is a new startup company they have no PO records yet, just inventory records so the form query failed. What i tried to do was...

...its usual one record ok) SELECT Sum([Products].[In Stock]) AS [SumOfIn Stock], Sum([Products].[Committed]) AS SumOfCommitted, Sum([committed]*[Unit price]) AS Expr1, Sum([in stock]*[unit price]) AS Expr2 FROM Products WHERE (((Products.obsolete)=False)); po-totals query: (produced an empty...

Hi! Yes the SQL to give the Cartesian results: SELECT tblTotal1.tot1, tblTotal1.tot2, tblTotal2.tot3, tblTotal2.tot4 FROM tblTotal1, tblTotal2; works fine as long as there is at least one record in the second table (tblTotal2) i used. However, if the 2nd table does not conatin any records...

Here's the results of another UNION query: SELECT tot1, tot2, &quot;&quot; as tot3, &quot;&quot; as tot4 FROM tbltotal1 UNION SELECT &quot;&quot; as tot1, &quot;&quot; as tot2, tot3, tot4 FROM tbltotal2; This too gave me 2 records: rec#1: tot1=blank tot2=blank tot3=$30.00 tot4=$40.00 Rec#2...

ok, tried to play around with Union some more and got no where: tblotal1 has one rec: tot1=$10.00 tot2=$20.00 tbltotal2 has one rec: tot3=$30.00 tot4=$40.0 Union Query: SELECT tot1, tot2, Null as tot3, Null as tot4 FROM tbltotal1 UNION SELECT Null as tot1, Null as tot2, tot3, tot4 FROM...

Yes, I thought about that and when I tried it, it gave me multiple records as the result. Since both source queries result in one record only with total field, the result with a union query gave me 2 records. What I want to do is make the two queries (or they could very well be unrelated tables)...

I have a query which needs to combine the reslts of two other queries so that the record set looks like one table with the combined unequal fields from both query results. The two source queries summarize some totals and create exactly one record of summary total fields. In my QBE grid, I have...