Search results for query: *

I have a guy doing some work on my website for me and he forwarded me a list of requirements. One of the requirements was that php should be able to connect to the mysql database. I researched a little bit and found php-mysql would facilitate this. I installed it via yum: #yum install...

I have a query that works fine for my initial database population, but I need another one for after that point. Basically, I have a field that comes out as DOMAIN1+username but all I want is the user name. So I came up with this mysql statement that works OK: update logfile set rfc931 =...

Hello, I know very little about vbscript; I usually am able to look at others at modify the code to do what I want, but can't write my own code for crap. I have a drive that I want to map out to everyone except two employees. I have used the following line to not map the drive out for one...

Hey all, I just accidentally erased my flash memory on my 1720 router, therefore erasing the ios that i had installed. Problem is: where do i find a ios that i can download. i don't need one with specific features or anything. i go to the cisco site and try to download, but when it get to...

I have a general scenario that I need to setup, but I just wanted to get pointed in the correct direction before I put more time into it. I have two sites that need to be connected. There was a T1 run between the two sites for this purpose. I have two cisco routers (1602 w/T1 card & 1720 w/T1...

I have a Cisco 851 router that I would like to use as my gateway. I can get to the point where it uses DHCP to obtain an address from the modem and can ping externally from the router. But I can't seem to get the routing set up correctly because I can't ping externally from my laptop. Basically...

Can someone think of a quick query that I could use to identify when a value shows up more than once in a table? The aren't necessarily duplicates, I'm just interested in one field that that value shows up more than one. I realize that I could sort the column and view them that way, but I want a...

I'm trying create a report that shows all records that don't have a relationship to a record in another table. Can someone think of a way I can do this? main_table name_table linked on id_number want to see all records in main table that don't have a relational record in name_table

Hello, Does anyone have a way I can halt a Macro if it determines that records in one table already exist in another table. I have been introduced to conditional expressions, but I'm not sure exactly how it works. Pretty much, I want to check the formid field in the dump_table and check it...

Hello, For a project that I'm working on I print daily reports and at the completion of the project we will print final cumulative reports. What is required is that each day the page number is increased. So on day one we printed the report and it spanned pages 1-3, then on day two the report...

Hello, Can someone think of a way that I can ensure that duplicate data isn't input into my database. I have a house_table that has a primary key which is form_id. Then a fname_table and a lname_table that reference the house_table via the form_id. So since there can be multiple first and last...

Hello, I'm trying to set up a way for my users to be able to enter one set of inputs, and have two reports returned. Currently they would pull up on report in which they specify a date and a district. The two reports use different queries to generate them and contain different information...

Hi, I am storing some sample data in two tables that reference. When a certain condition occurs, I want that data in those two tables deleted. I'm having a hard time removing those records. Here is my SQL code behing the delete query DELETE fname_table.FormID, fname_table.name_id...

Hello, I'd like to have a query that pulls out records that are marked yes as callbacks, then inserts hard coded text into the fname_table and lname_table. Here is the SQL code behind my append queries, but when I run them nothing happens. INSERT INTO fname_table ( formID, first_name...

Hello, I have a table called house_table that references lname_table and fname_table. So a house may have 1 last name assoicated with it or 2 or 3 or whatever. What I want to do is have a form that shows all information for a house shown in multiple text boxes, then have all names assoicated...

I'm trying to develop a form that can delete a record, but I want to track all deletions. What I've been trying to do is run an append query to take the selected record in the form and append it to my delete_table, then it deletes the record out of the main_table. My two problems are: -How do I...

Does anyone have a favorite online VBA reference that would help with developing Access databases

Hello, I'm using a macro to run multiple append queries that split one table into multiple tables. What I want to do is look at the primary key in the dump_temp table. This is the table that data gets imported into my database. Ok, so i want to look at the primary key in the dump_temp table...

Hello, Does anyone know how I could generate a rather long random field that I can use as an unique identifier. Alph-numeric would be awesome. And 15 or so digits I think would be a larg enough field Any help is welcome!

Hello, Is there anyway that I can print a set of records, but have records with a different date start on a new page. So for 8/29/2006, I have 37 records which takes up 1.5 pages; then I would want records for 8/30/2006 to start on page 3