Search results for query: *

Long shot here but I thought I might ask. I have some code. 2 functions. I can not quite fiqure out what it is doing. It appears to be returning some type of array but not sure how to handle results[] /// ----------------------------------------------- function handleHttpResponse() { if...

Hello, How can I select records from table 2 that are not in table 1 if the are some how related. I basically have some updated information from an orginal spread sheet I need to add to the database as new records.

Hello, I am trying to select a null or empty date field. I have tried writing a sql in access select * from table_name where date_field is null; or select * from table_name where date_field = ''; How can I retrieve this info??

Hello, Using Autocad Map 2004. WE converted a shape file that has object data for street names. Went in and built a query to return the text value of the data in Autocad and the text returns fine but the alignment is set to 0 degrees. We are trying to return the angle value of the text also, so...

Hello, I am using Autocad Map 4 and I am trying to use some of Maps advance features. I have a ton of attribute data in the map attach to the lines and some blocks and I would like to pull it out and store it in either an excel spread sheet or access. I have a ton of tutorials on how to use it...

Hello, building a time report. table structure --- userid varchar2(10) punchtime date typeofpunch varchar2(20) rec_id number --- Data for time is entered as sysdate for punchtime and typeofpunch shows if they are (login, out_to_lunch, in_from_lunch, end_of_day). Can anyone help and show me...

Does anyone know how I could explain this how to to a friend this question she posed to me I have MS Access with a table of 500 rows of data. How do I build a report the a. selects the total count and shows it at the report header and b. select from the same table where field_1 = field_2 I...

I create a basic view. I then create a stored procedure that takes a input varible and calls the view; create procedure schema.SP_NAME (V_value varchar2) var_a varchar2(30); var_b varchar2(30); as cursor CUR_RATE is SELECT field_a, field_B, FROM view_name WHERE field_A = V_value; begin for...

When I run this code in SQLplus it works perfect. select distinct agent_name, (select count(agent_name) from agent_table where kudo_QA = 'KUDO' and agent_name = b.agent_name) Kudo, (select count(agent_name) from agent_table where kudo_QA = 'QA' and agent_name = b.agent_name) QA from KUDO b...

I am trying to see if a record has already been enter into table_1 (don't want redundancy). If table 1 has the data i want to enter, just add data to the second table. If Table_1 has no entry add data to table_1 and Table_2. I do a select to find out if there is a record that matches table_1...

Guru's I have web reports running on our intranet use everyday. To get them 'user friendly' we bought a program called recrystalized, which makes it really simple to create .asp pages that allow parameters as webpage entries, passwords to the database etc.... works really well and I can publish...

Have a report that is going to be used to calculate a deposit amount for a customer. The rules are: State 1 1. The highest bill for last year = deposit.. State 2 2. The sum(two highest bills)*2.5 last 12 months. The reports selects 12 months of billing, sums it up for each month and gives me...