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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Taking this a bit further....
What I'm trying to do is include a different content file each day, so I tried this, but clearly doesn't work! What I want is to load (today) ./content/91.htm $pth['folder']['content'] = './content/'; $pth['file']['content'] = $pth['folder']['content'].$date("z")'.htm'; Thanks for your... -
Create a number for each day
Thanks, and also for the link to the manual. Great help. Now I know where to look in future. Liark -
Create a number for each day
php newbie here. Could someone help with what I think is a simple piece of php? I need a number for every day of the year. e.g. Jan 1st = 1, Jan 2nd = 2,... Dec 31 = 365 (or 366). How can I do that in php? Thanks Liark -
Field pointing to same table
Thanks, both. I have chosen Rudy's solution simply because I don't have to redesign the database, and it works a treat. Thanks to Lyndon too for your help. Liark -
Field pointing to same table
Hi Lyndon, Thanks for the reply. No, the second record points back to the first record. The reason it exists is because a number of people in the list can select a 'partner' - which comes from the same list. This action populates both records. Liark -
Field pointing to same table
I am a bit stumped. I have a table with an index, the table includes firstname, lastname, and a pointer to the index of the same table, different record. e.g. ID, FirstName, Lastname, Pointer where pointer is the ID of a different record in the same table. What I want to produce is a... -
formatting textarea box
You can customise it as you wish. There are standard buttons and you can add and remove as you like. In the example I've used the advanced option but removed loads of buttons I don't want, and added a date button (plugin). The docs explain it quite well. Hope that helps. <script... -
How do I get rid of the space at the top of my webpage?
Forgot to mention, to get the code bang smack up, change the table to: <table width="800" height="130" border="0" cellspacing="0" cellpadding="0" align="center"> Liark -
How do I get rid of the space at the top of my webpage?
R21 This is a style problem, insert the code below in your <head> statement, between the <meta.... line and the </head> line, and it will work fine. On the other hand, you could take the code below (without the first two and last two lines), save it as a file in it's own right (style.css)... -
ASP page inside of a .CFM page..
You can include asp in coldfusion: <script language="javascript" type="text/javascript" src="poll/vote_js.asp"></script> Hope this helps. Liark -
Sorting on the difference between two fields
Brilliant. Thanks r937. Liark -
Sorting on the difference between two fields
I have two fields in a table..... in my select statement, I'd like to select a variable as THE DIFFERENCE between these two fields. Is this possible? i.e. SELECT (abc - def) AS ghi FROM table WHERE.... this is the code: <cfquery name="gettopmovers" datasource="abc" maxrows=10> SELECT... -
Unique matches in two tables
OK, thanks. I have it working - I wrote the code a couple of years ago, but you're right - it is a world of hurt. I keep coming back to it trying to think of ways to normalise the tables. On day I will do a complete rewrite - as with a lot of things it grew organically, so I didn't really know... -
Unique matches in two tables
Thanks for your help, guys. I'll elaborate a bit - both tables have many records. There is one record in table 1 (containing ten fields) which corresponds to many records in table 2 (containing ten fields). The records are linked by a key. So table 1 will have a key value (e.g. 1234) and in... -
Unique matches in two tables
Here is my problem: I have two tables, each table contains ten unique letters. How can I compare the two tables to give me the number of matches? eg table 1 has: q, w, e, r, t, y, u, i, o, p and table 2 has: z, t, q, g, j, a, u, s, r, m The answer I need is: 4 I don't need to know which... -
Select correct record from table
It's just an Access database. Thanks for your help. Liark -
Select correct record from table
I'm passing accross url.name which is a concatanation of two fields in a database table (forename, surname) Please, how can I select that record from the table? SELECT * from person where 'per_forename per_surname' EQ #url.name# Liark -
CFGRID problems/alternatives
Have a look here: http://www.webtricks.com/sourcecode/code.cfm?CodeID=6 Liark -
Counting all occurancies in a table
I have a table which has ten fields and any number of records. I have another table with one field and ten records. (it has more than one field really but that is not important) I want to loop through the first table looking through its fields for each occurance of entries of the second table... -
Top1 record for each employee
I needed the last record entered by a user too - thanks for this code - works for me like this: SELECT a1.SocSec, a1.BeginAbsenceDate, a1.AbsenceCode FROM tblAttendance AS a1 WHERE a1.BeginAbsenceDate = ( SELECT MAX(a2.BeginAbsenceDate) FROM tblAttendance as a2 WHERE a2.SocSec =...
