ray_broome

Hi, I have a situation where i am inserting to two tables from a web form but the first table needs to be inserted to so i can get the PK, then use the PK to insert into the second table. So what I would like to do is rollback …

Hi, I'm now starting out learning blackberry development, in hopes to eventually create an app using google maps so that mobile users can report different types issues and pinpoint their location (it is supposed to be an app that will hopefully be used by government). What i'm wondering though is …

Hi, i'm new to ASP.NET, been using PHP for a while but now getting into ASP.NET/C# and was wondering how i would go about accomplishing the task in the title. I'm still an ASP noob right now so any suggestions/help is welcome. To do something like this normally I would …

Hi all, I'm trying to create a more customized version of the prompt function built in by javascript where i basically use some dhtml to bring up a div made up to resemble the javascript prompt window. I am getting some problems with hiding/showing it though. Here's the javascript: [code=javascript] …

Hi, I've got a form with a few text fields, and only today I noticed that when i tried copying some text from an email and pasting it into one of the fields, after submitting to the database (and printing the query), i noticed that the name sent had something …

I'm trying to carry out the following delete statements [CODE]DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num …

Hi, I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user …

Hi, I have the following query i'm trying to execute: [CODE="mysql"] SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name, cn.common_name, GROUP_CONCAT(cn.common_name ORDER BY cn.common_name SEPARATOR ', ' ) AS common_names, ui.unvouch_image_src, ui.unvouch_image_alt, gh.growth_habit, gd.gen_distrib_name FROM plants AS p LEFT JOIN (genera AS g, species AS s) …

I posted a similar question in MySQL section before but i think this one might be more general/easier to understand (hopefully): I'm doing a database (in MySQL) of different plants which is gonna store various (somewhat detailed) information about them. Here's a sample of two tables: Families (Plant Family) [code] …

Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon …

Hi, I am writing a java application where i am trying to create an arraylist of "Item" objects. An Item has certain methods such as getStartValue(), etc. What i am trying to do is to access an Item within my arraylist using operator[] and then call a method for that …