Search results for query: *

Greetings, I have items in a database, and want to create a little custom markup. What I'd like to do is be able to search my text and replace "" with "<a href=http://localhost/foo.php?x=37>(some link text looked up based on the '37' or whatever the value is)</a>". I found some code that let's...

I am trying to find a path between zones for delivery. I'm looking at taking 2 zones, and finding the trail of connected zones between them. I'm figuring: Table: zones id int zone varchar(32) Table: links id int zone_a int <- FK zones.id zone_b int <- FK zones.id Wondering if there's a JOIN I...

Scene: 1 Ubuntu (Hoary/5.04) Linux box running PostgreSQL 7.4.7 Tables: invoices id integer (sequence) inv_number char(11) invoice_details id integer (sequence) inv_number char(11) FK to invoices.inv_number, required, not null amount numeric(8,2) Now, I need to, once getting all...

I'm curious if anyone can give me a scenario where two seperate appliances/devices on a given network can have the same IP address. My situation: the 6-figure-a-year manager had trouble getting the wireless router configured. The actors in this little tragedy being a dsl-modem, then the...

Here's my setup. Gateway box is running Windows XP Home ( Service Pack 1, Norton Internet Security + Antivirus with updated Definitions), 2 internal boxen running Fedora Core 3. I got up Monday morning after a loooong overnight 89MB download on this dialup connection. Had a security alert...

Greetings. First post to this forum. Trying to compile this code on my Linux box using gcc 3.3.3. I get the following warning: gcc -Wall -O -ggdb -Dunix -DNOCRYPT bitsys.c -c -o obj/bitsys.o bitsys.c: In function `str_flag_string': bitsys.c:80: warning: operation on `toggle' may be undefined...

Greetings! I have a combobox with a pk_id (hidden) and name of employees. I have a filter on the source query to only return the 'active' employees. My problem is how do I set the initial load value of this combobox to the first record returned by the query? I can't put 'pk_id = 1' in the...

Greetings! Just tossing this out to see if anyone has some input on it. I have cleaned the problem files, and am now trying to reflect on how it happened. Windows XP Home + Service Pack 2, Norton 2003 + definitions dated 8/24 or so. I run no special background stuff, surf with Firefox, don't...

Greetings! It would seem 'way back when' that I had added an integer column to a table that was a foreign key to another table, then put in a one-to-many relationship. Long story short, after all this time, I have deleted the extra column and other table, but when I hit 'F9' to refresh a...

I have been a Linux user off-and-on both professionally and in my hobbyist personal life for quite a few years now. I had something new and ... exciting? ... happen to me yesterday. I noticed some quirks with qmail (yeah, I was messing with it, poking around with some utility scripts I found)...

I have a workbook that has been working for the last year. There a little VBA code, but mostly dirty hacks using vlookups (I keep swearing it'll go into an Access db Real Soon Now ;-)). The other day I modified an existing, working bit of code that did Application.ScreenUpdating=False, deletes...

I am trying to take my database (currently Access 2000, soon to be MySQL 3.53, hopefully PostgreSQL once I get a grip on it) from the dark ages of weekend hacks to a solid, well-formed and normalized pile of data. Something I want to do is be able to perform some cost-analysis by taking revenue...

Greetings! I'll admit to not searching for an answer before asking right up front. I'll search a bit later, but it's my day off and am hoping to have a couple pointers in the right direction when I go in the office tomorrow morning for work :-) I'm wondering if there's a programmatic way to...

I apologize in advance. I haven't searched, googled, etc. It's late, I'm beat. Curse me if you want :-) I have clients, each gets a few trucks. Convenience has named this trucks things like 'truck 1', 'b truck', etc. I have this stuff stored in a 'dat_pseudotrucks' table (ID,client,name)...

I'm working on a database for a friend's growing trucking company. I need to generate a 'manifest' number, thinking the format 'YYMMDD'+UNIQUE (YearYearMonthMonthDayDay+Unique 3 digits) is sensible. I'm wondering what's a good way to get the next manifest number. * Ok, need to set up a new run...

Apologies in advance. The forum FAQ didn't address this, and I'm killing myself trying to figure it out. I just need to get phpPgAdmin to let me log in. I know it's not postgres-enough for this forum. But I think my problems are related to my users, hosts, etc. If someone would be kind enough...

I want to simplify my current working form. Right now, it queries mysql server, works through the $result producing a <form> with <input>s and then a submit button that has the ?record=$rowid in the action. That all works. What I'd like is to get this down to a single form and a single submit...

Okay, I know it's like sticking my head out and begging for it to be cut off, but bear with me, it's nothing evil :-) I bought a program (AM by http://www.intranet2internet.com, the free AccessDUMP tool is great too, check it out). For some reason when I try to use it to connect to my MySQL...

Greetings, I have an Access database that I'm trying to get migrated to MySQL. There are a few types of tables I currently have in the .mdb ('pay_*, inv_*, dat_*). I'm wondering if it's preferrable to keep the single database with multiple tables, or do multiple databases with the more 'data...

I am setting up a form that will have 20 'rows', each one holding several <input> fields (probably 3, invoice number, customer name, and zip code). These will get inserted into a mysql database later. When I submit the form, I need to loop through the data, build my INSERT query for each row...