Search results for 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...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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