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 Rhinorhino 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
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
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 -
Delaying page loading or sequence of events
I am designing a web site which requires log in. After a person logs in, they are redirected to an information page. On this page, they will get a welcome message and then it will execute some php code to check for certain events: Example: Checking for pending requests...................DONE...- JMay0816
- Thread
- Replies: 14
- Forum: Javascript
-
Displaying a Progress bar between code snippets
I would like to display a progress bar in between my code statements. Is this possible with PHP and if so, can someone lend a hand? Example: Checking for pending requests: <progress bar> - display if any found Checking for overdue requests: <progress bar> - display if any found -
Coding for an "OnClick" event
I am trying to code an image file for an onclick event. It works outside of the php coding but not inside: This works: <td width="3%" align="center"> <img src="Images/archive.gif" alt="View Revision History" border="0" onclick="MM_showHideLayers('RA','','show')"/> </td> This doesn't: <?php... -
PHP IF statement.....
Is there an easier way to code this: if $a==1 && $b==2 || $a==1 and $b==4 something like: if $a==1 && $b IN (2,4) don't know if PHP will allow to simply the if statement. -
Handling Files with spaces and extra characters
I have created a web page where a person can upload files to a designated location. All seems to work fine if normal file naming conventions are followed. (I.e. no spaces and only one "." - test.doc). How do you handle files with spaces and other characters such as extra ".". I.e. This is...
