Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SenTnel

  1. SenTnel

    Problem creating labels to dynamically generated output

    Hello! Im having problem generating the labels for content created by the following function: function setOutput(){ if(httpObject.readyState == 4){ var answer = httpObject.resultsponseText.split(","); var results = document.getElementById("resultsultadosScan1"); var article =...
  2. SenTnel

    Need to Merge two identical tables

    Nice! Superb! worked great! Thanks a lot!
  3. SenTnel

    Need to Merge two identical tables

    The two tables are identical, one contains info from hospital 1, the other from hospital 2, I need to combine all the data in just one of the table, but, since both hospitals were running the application as "localhost" both tables started theirs Id's in no. 1, now I have both hospitals with...
  4. SenTnel

    Need to Merge two identical tables

    Thanks! This is the table info. CREATE TABLE `areas_sub_local_obj` ( `Id` INT(11) NOT NULL AUTO_INCREMENT, `Code` VARCHAR(40) DEFAULT NULL, `Nombre` VARCHAR(255) DEFAULT NULL, `Fecha_Inscripcion` DATE DEFAULT NULL, `Hospital` INT(11) DEFAULT NULL, `areas_sub_local_obj` INT(11)...
  5. SenTnel

    Need to Merge two identical tables

    I need to merge to identical tables, but one column (areas_sub_local_obj) has a reference to the Id column (Primary Key). I need a script to insert the data from table 1 into table two and to change the value in the column areas_sub_local_obj to the new Id that corresponds to the original...
  6. SenTnel

    MySQL select to return most recent record

    Thanks DonQuichote! I do understand, from what I've been reading, that what I need is the max function, the problem is that Im learning and don't have a clue on how to use it in this case, I mean, im not capable of writing such select. Your spanish is correct: Hora is just Time, and Fecha is...
  7. SenTnel

    MySQL select to return most recent record

    Hi! We have a database that stores vehicle's gps position, date, time, vehicle identification, lat, long, speed, etc., every minute. The following select pulls each vehicle position and info, but the problem is that returns the first record, and I need the last record (current position), based...
  8. SenTnel

    IIS and Xampp problem with ISA server

    Hello! We have a Win2003 Server with ISA 2004, single network card, running a website with ASP application on IIS and we also have another website runing a PHP-MySQL app, the ASP site works on port 80 and the PHP runs on Xampp-apache port 8080, both sites are working fine internally, and the...
  9. SenTnel

    shp2pgsql Help with syntax!

    Hi! Thanks! This is the table structure, and the way im trying to create the table (somenthing i don't understand is where do i specify the database and schema, it only says create table): BEGIN; CREATE TABLE "postgres" (gid serial PRIMARY KEY, "street" varchar(40), "to_left" int4...
  10. SenTnel

    shp2pgsql Help with syntax!

    Hi! New to postgres, im trying to import shapefiles into postgres 8.2 using shp2pgsql but so far have failed. I tryed using the -p option just to prepare / create the tables then insert the data, but no luck, please help me writing the correct syntax to acomplish for the following: Shapefile...
  11. SenTnel

    Blob field: delimiting text, exporting

    Thanks!
  12. SenTnel

    Blob field: delimiting text, exporting

    Hi all! I have a table that contains a column (blob, text type, formatted as MEDIUMTEXT) with text hyphen (-) delimited, listing rooms by numbers, and I need to export or insert that data into another table, where all other info on the other columns remains the same, but I need the data on...
  13. SenTnel

    Problem connecting to server console (mstsc -v:xxx.xxx.xxx.xxx -consol

    Thanks Dublin! I checked the event viewer, nothing unusual, no error messages, just regular logon / logoff events, as if they were regular, I mean, like I explained, I entered username and password, few seconds later the screen desappears, and now I realized that it does logon and then logoff...
  14. SenTnel

    Problem connecting to server console (mstsc -v:xxx.xxx.xxx.xxx -consol

    Hi all ! I have a virtual dedicated server that accepts remote desktop connections with no problem, but I need to install an application that when the installation proccess starts pops a message telling me that it cannot install via remote desktop, that it has to be console mode. So when I try...
  15. SenTnel

    Application works for administrator, not for users !!!!!

    Problem solved! Permissions on the registry! ... thanks.

Part and Inventory Search

Back
Top