Search results for query: *

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

Hello Folks! I am using 2 separate SQL queries to accomplish a task and I was wondering I can combine these 2 queries into one more efficient query? My database table may have more than one entry if queried by Telephone number. I only want to extract the record information only if there is ONE...

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

Hello, MS Access 2000 sp3 When adding a new record to an order file, I have a default value on the ordnum field. It also has a format = "9999\-999". The default value is "0603-". When the user clicks on the new rec nav button, the form has the correct default in the ordnum field "0603-"...

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

Hi scriverb, Unfortunately, I dont have a common field between the two qeries, otherwise I would create an outer join. In reality here are the 3 queries....i didnt post them before because I was trying to sikmply the problem and use an example from a &quot;ply&quot; database and duplicate the...

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