Search results for query: *

I have the problem: "List all details about software records. Sort the output by package ID within tag number." I'm a little confused about what they mean "within tag number" Is the following sql right or wrong, if wrong can you help me fix it? Thanks. Select * from software order by PACKID...

Hey, Let's say we have two table both the fields "first name", "last name", and "address". Which of these fields intersect? I mean don't all three intersect since there common to both tables? Or is this some special property for two tables to intersect other then them having the same field...

As for I know this is a valid sql statement, but for some reason access gives me a syntax error. How can I fix it? Thanks. SELECT SUM(CASE WHEN City = 'Sandnes' THEN 1 ELSE 0 END) as FieldNeeded1 FROM Persons;

Why is this illegal and how can I fix it? Thanks. SELECT COUNT(*) AS NumberOfHistory FROM Enrolls WHERE COURSENUM = 405; SELECT COUNT(*) AS NumberOfScience FROM Enrolls WHERE COURSENUM = 605;

to do a POST or GET request on it. Except it has to be in ssl3 since its a https site. thanks.

https website. ie:https://www.somethinghere.com/

How can I do https(ssl3) in c# without using the mentalis control? Thanks!

what is wrong with the following code? WHERE Ratings.Rating = (Coffee.Rating AND Country in('Dominican Republic', 'Jamaica', 'Colombia', 'Venezuela', 'Mexico'); country is in a table called Coffee if that helps. Thanks for any help!

anyone?

I just need help with the if statement ie: if state = 'NEW YORK' AND salary > 20000 AND age > 40 can you use two ands like that? or is there another way?

Ok lets say I have an area for STATE, AGE, and SALARY. And I want it to be like this: 1. state = new york 2. age = greater then 40 3. and salary greater then 20000 Do I need 3 actual if statements? or 3 ands? thanks for the help!

Thanks guys, what does the 1 and the 4 stand for in MOVE Fieldname(1:4) to P1. ? Thanks again. I haven't seen a move like this until now.

Lets say the length is just like that 12 characters. For example I want to seperate 0000abcd123 and print out to the printer 0000 abcd 1234 under those headings. Get what Im trying to say??

Hey Again, How would I go about doing this? Lets say I have data like this: 0000abcd123 0001efgh123 0002ijkl123 0003mnop123 And I want to lay it out like: Code Letters Numbers 0000 abcd 123 0001 efgh 123 0002 ijkl 123 0003 mnop 123 I know how...

ROFL!!! All I had to do was change AFTER ADVANCING 2 to AFTER ADVANCING 4. heh.

anyone?

How would I go about fixing that?

If I type: WRITE PRINT-LINE FROM OUT-REC AFTER ADVANCING. It still doesnt give me the space that I needed. Why?

I believe we telnet into a IBM-370 or 360. Ok so how would I double space all my output?

Ok I'm trying to add the after advancing constant in the write command to double space my output. Here are all the write commands in the code: WRITE PRINT-LINE FROM OUT-REC AFTER 2 WRITE PRINT-LINE FROM HEADING1 AFTER TOP-PAGE. WRITE PRINT-LINE FROM HEADING2 AFTER 2. how do I add double...