Topic profile page for Database query.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Database query.
Topic "Database query" was discussed 0 times on 0 sites in last 3 months
Started 2 weeks, 1 day ago (2009-12-18 09:32:00)
by Buddies
I have very little Database Experience, and I need a little help. I am using sqlplus to manipulate an Oracle 10g database. I have two tables I want to use to create a new table. Table_1 has a column that references data in Table_2. I want my new table to contain all of the information from Table_1 + one column of Table_2. Table_2 includes data from a bunch of other tables I do ...
Started 2 weeks, 2 days ago (2009-12-17 17:25:00)
by rbarnett
I'm trying to modify a query in a particular module, privatemsg. The query is $query = "SELECT name FROM {users} u WHERE name like '%s%%'"; The query simply grabs the user from a search box. I'm trying to modify it so that it can search values from another table, profile_values, provided by the Profile module which I'm using to display "real names." My goal is to allow a user to ...
Started 2 weeks, 2 days ago (2009-12-17 06:01:00)
by tomlancaster
Hello, I have recorded a macro to perform a database query, but I would like an input box to prompt the end user to enter the data they would like to query. This is the department ID (e.g. 123456) I have so far got the following code: Code: Sub Look_Up() Dim fname ccode = InputBox("Enter the Department Code of the Staff would like to lookup...
Started 2 weeks, 6 days ago (2009-12-13 22:28:00)
by user651239
Hi: i created a small database about 25 to 30 tables for the some general bussiness information. it is used in web base application (internet). i want to make it fast means it gives the result as fast as possible. can you please help me to make it fast or give me some document or ebook about the databse tunning. Regards, Abhishek...
Started 3 weeks, 4 days ago (2009-12-08 12:55:00)
by artbondoc
Hi, Im new to this forum and coldfusion. I am getting an error from cf and the error is referencing where it occured. here is the line # where the error is occuring... 210: 211: '#thisCell#', 212: 213: ' ' 214: ) ; Any help from anyone would be very much appreciated. Thanks.
Started 3 weeks, 5 days ago (2009-12-07 19:30:00)
by w2e
urgent help needed. it looks like every database query goes through the entire database: Rows_sent: 123570 Rows_examined: 371018 (see mySQL log below). Anybody can help with this? # Query_time: 5 Lock_time: 0 Rows_sent: 123570 Rows_examined: 371018 select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p....
Started 3 weeks, 5 days ago (2009-12-07 19:29:00)
by David Blake
I have a query that is to display the contents of a database query. I have it set to display in a table. I have a textfield in this table in which the user can update a field and with that, want an update/submit button at the bottom that will send the updated info to the database. What's happening right now is the page displays the submit button below each entry in the database. ...
Started 3 weeks, 6 days ago (2009-12-06 22:57:00)
by user647572
Hi, I want to display report in which i want to display total count of the value for that particular year but like 1995-96 in that it will gives information from Apr-1995 to Mar-1996. not whole year data. But i can restrict this month as financial year in query?
Started 4 days, 20 hours ago (2009-12-29 08:50:00)
by techkenny1
Hi all I want to be able to run an append query from another database via a command button. Is this possible? If it is how do we get a path on the command button so that it sees the other DB. Many thanbks, KP
Started 4 days, 17 hours ago (2009-12-29 11:48:00)
by sxschech
You could also use the "IN" statement in your append query (or Select, Update, etc). This example shows appending from the table in the other database to another table in that same "other" database from the currently open database. You could change the IN to refer to a different "other" database, or you could remove the IN for the part that you want to remain in the currently open database....
Started 5 days, 16 hours ago (2009-12-28 12:43:00)
by tonality
Hi. I just ran into this same issue. As for your TNS question, you do not need to have that info in the connect string as long as you have an oracle client on the execution server, which you'll need for the test anyway. I used the 10g express client to minimize install size and config and it worked beautifully, and can use the tnsnames.ora file to support load balanced and quick naming ...
Started 5 days, 10 hours ago (2009-12-28 18:37:00)
by yosiasz
> I think if you use the following dynamic pivot you can have the unique id as a column and the count as rows.. http://sqlblogcasts.com/blogs/madhivanan/archive/2 008/08/27/dynamic-pivot-in-sql-server-2005.aspx If you don't have the passion to help people, you have no passion
Started 3 days, 1 hour ago (2009-12-31 03:05:00)
by stampeder
The FCC uses that Tiger database tool for their own purposes too. I find it really slow. Here's the official FCC way to get more specific station info, including contour maps: http://www.fcc.gov/fcc-bin/audio/tvq.html Hint: you don't need to fill in all the blanks. You can just put the call sign letters in. Entering WCFE led me to this map: Note that the map does not give the ...
Obviously you have a potential SQL injection wherever the user agent is used against the database in your script. You need to make sure its content is properly escaped before using it in a query. You don't mention what you actually use at the backend, but since you mention mysql_real_escape_string() I'm going to assume PHP. Just search for $_SERVER['HTTP_USER_AGENT'] to see how it's used in ...
Started 1 week, 1 day ago (2009-12-25 09:57:00)
by Lingzhi Sun
Hello, First, you are retrieving the data as anonymous type. However, the anonymous type is read-only. I recommend you to retrieve the whole entity objects if you want to update them later. Besides, to update a row, the primary key value is necessary. Best Regards, Lingzhi Sun
Started 3 days ago (2009-12-31 04:55:00)
by Tony Toews [MVP]
"Jeff Boyce" wrote: Have you tried opening the second Access db and importing the query from the first? BTW when I have to do this and it's only a few objects I open both databases simultaneously and then drag and drop the objects from one database container window to the other. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca...
