Search results for query: *

Yea that is what I been trying to fiqure out. I think I am going to throw out all this and just return yes is pass if the insert worked and false with what is not right I will eval it on the php side of things, since I don't know a whole bunch on the java script side. Thanks

I am trying to return some values from a firefox tool bar with 3 inputs. Fill in the tool bar, pass the vars to a php page, insert it into the database and return either succes or failure popup. The popup would also eval the three parms and say oops you forgot var1 or var2 or var3. I have the...

Thanks Little beefer than I need. How could I change the code for an array to do a popup that said Success the code worked or Nope it didn't work Thanks

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.

ok. that worked. It also helps to use the correct column name also.(complete_date vs. completed_date. THanks for the help.

Didn't work. The field is supposed to be a date field called completed_date. I just want to find all the orders where the date has not been entered. Very simple query in Oracle. Not sure about this MS Access

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. When importing shp files into Autocad using mapimport4 and requesting object data to be brought in, all the data from the shp files are carriered over, so the data is there. Using Edit Object Data (AutoCad Map) and clicking on a point produces the data attached to the point (Autocad Map)...

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...

I might have a different problem. It appears that the data was created using Autodesk Map 4 "Define object data" under Map->Object Data-> Attach / Detach Object data and is not all ways a block. It creates tables in Autodesk Map and stores the data in that sense. I am wondering how to export...

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...

Can you show me an example?

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 did some reading on Exceptions, EXCEPTION WHEN NO_DATA_FOUND THEN INSERT TABLE_1 VALUES (X,C,B); END; at the end of the store procedure and got it to work. I am going to keep playing with the sql statement, and see if I can get it to work also... Thanks so much for the all help...

hello, I do not want to over write the orginal entry(if there is one), will this work(WHERE NOT EXISTS): INSERT INTO Table_1 SELECT x,c,b FROM sys.dual WHERE NOT EXISTS (SELECT 1 FROM table_1 WHERE service_number = value_1); INSERT INTO table_2 VALUES (q,e,t); JP

...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 into a varible ******* select value_1 into v_var from table_1 where service_number = value_1. ******* I then do a if then statement ******* if v_var is null then...