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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report with two Content Sections and one query
Sure hoping someone can assist me. I'll give a little history first. A while back, I created a very nice report with a couple different content sections. This report utilized one query. To keep it simple, we'll say this: select item1, item2, item3 from tbl1 where item3 in ('A','B') Very...- JMay0816
- Thread
- Replies: 0
- Forum: Actuate Reporting Solutions
-
Query two fields on same table including NULL
I have an interesting item here. I am trying to pull records from a table by comparing two fields (a.Field1 <> a.Field2) It works fine when both fields have actual data. However, there are several records where Field2 is NULL. Is there a more efficent way of coding the WHERE clause without... -
Help with complex query
I'm a little baffled on this one. Here's what I have: 2 tables which both share several common fields. I'm only dealing with two. It's a one to many relationship (only one record in table1, as opposed to possible many in table2) Snapshot of data: Table1 RecNum ------- Item 2009001... -
Interesting Security Issue with Power Users Group
I can't place my finger on this one and need some assistance. It seems that users in my Power Users group can not access anything anymore. For instance, if they attempt to access an Excel file, they get access to read-only file is denied. If I move them to the Administrators group...all is...- JMay0816
- Thread
- Replies: 1
- Forum: Microsoft: Windows
-
Tough Query Help
Need some help retrieving a additional field for a query. Here's my sample data: DB1: PartNo: PDescription: Status: Master: 100 widget assembly #1 Active 101 widget assembly #2 Active 102 widget assmebly #3 Active 103 drive line... -
Add a prefix to a field you select?
Can you add a text prefix to a field you select from a select statement? Example: Select field1, field2, field3 from table2. I would like it to look like the following: field1......field2........field3 Pre-<data> 34 square Pre-<data> 22 circle so i want to append... -
Cisco Wireless Bridge
Not sure if this is the correct forum for this question (please redirect me if it is). I am looking to connect a remote location to our main LAN via a wireless bridge (Cisco 1310). I was going to use a WAP (Cisco 1100) at the facility end but someone told me that a bridge can only communicate... -
Wireless serial bridges
Not sure if this is the correct forum for this question (please redirect me if it is). I am looking to connect a remote location to our main LAN via a wireless bridge (Cisco 1310). I was going to use a WAP (Cisco 1100) at the facility end but someone told me that a bridge can only communicate...- JMay0816
- Thread
- Replies: 0
- Forum: Network Appliance networking solutions
-
Selecting records from multiple tables using Left Join
I have a tough query that I am trying to hammer through. Hoping someone can help. Trying to use three tables. So I start with this: select a.field1, a.field2, b.field1 from table1 a left join table2 b on a.field1=b.field3 where a.field4='W' and a.field5='N' group by a.field1, a.field2... -
-
Changing FONT in phpmail
I have created several different system generated email messages using phpmail. One question that was recently brought up to me was if I could make certain items BOLD or even change the font color to red. I haven't found much about this...so is this at all possible? thx -
UNION with Group By
Finally got it: select distinct email from ( (select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2)) UNION (select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where... -
UNION with Group By
Finally got it: select distinct email from ( select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2) UNION select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where... -
UNION with Group By
that still returns four records instead of the desired two. -
UNION with Group By
I am selecting records from two tables: select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2) UNION select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where... -
Problem with INCLUDE statement
bingo....somehow the file was not saved in the correct location. thx -
Problem with INCLUDE statement
only the code up to the INCLUDE statement is shown...which is actually the very first few lines on the page. As for the gensysmess.php page....yes...that is the only code on that page (for now). Just the two lines. -
Problem with INCLUDE statement
no error messages...however the INSERT query on the second page does not insert the record from the INCLUDE statement. If I move the query code to the first page in place of the INCLUDE, the record gets inserted. Therefore, by not working, I mean the code is not executing via the INLCUDE... -
Problem with INCLUDE statement
I'm having an issue using INCLUDE. On the first page, I have the following code: <?php require_once('config.php'); session_start(); $uid=$_SESSION['uid']; // UserID variable $tdate=$_SESSION['tdate']; // Current Date variable $tdate1=$_SESSION['tdate1']; $connect=mysql_connect($host... -
Query by dates to find history records
what is the correct way to query on a date field in a table to pull a value that is older than 3 days? Date field format is 2007-04-04 I only want records where the date is 2007-04-01 or earlier. thx
