Search results for query: *

Hi, I want to insert one row per each value of listingsdb_id into a table with the following fields: field_name, field_value, listingsdbelements_id, listingsdb_id, user_id There are an unknown and variable number of rows already in this table for each unique listingsdb_id. I've tried the...

I am stumped as to how to make this work. I have the following elements: UPDATE default_en_listingsdb as r1 INNER JOIN default_en_listingsdbelements as r2 ON r2.listingsdb_id = r1.listingsdb_id AND r2.listingsdbelements_field_name = 'MLSID' AND r2.listingsdbelements_field_value...

I'm new to PHP programming and am having trouble with variable scope. If I echo the value of $data within the following loop, I get the expected values. How can I transfer those values to an array that I can access outside the loop? while ($data = mysql_fetch_array($result)) { for ($i=0...

When I run a php program from its gui interface, it operates correctly. When run from cron, it works properly except that it fails to unlink and rewrite a batch configuration file (to update the last date/time run) saying permission denied. Can anyone tell me how to get a this to run with my...

Hi, I'm new to php programming and am looking for ideas. I am working with a program that generates web pages from database information using templated forms. Some of the database fields contain options that are formatted as a bulleted list in certain areas of the page, but as pipe separated...

I want to change the listingsdb_featured value for records returned by this query to 'yes'. I was hoping to use update, but haven't found a working syntax. Can anyone assist? SELECT listingsdb_featured from default_en_listingsdb as r1 LEFT OUTER JOIN default_classlistingsdb as r4 ON...

I would like to display the latest UTC date/time value in my db as the date/time it would have been in my time zone. The following returns null. Can anyone tell me what is wrong with the query. Perhaps it is that I'm not referencing the time zones correctly, but I couldn't find how to...

Hi, The primary key for this table is an auto-incremented field called listingsdbelements_id. I want to concatenate (streetnumber,streetdirection,streetname,streetsuffix)from the following query into an address field. I was looking at...

I have a page that is generated by php from a main template and sometimes, subtemplates. I added a div enclosing the subtemplate in order to put a border around the subtemplate contents, which include varying numbers of photos and varying amounts of text. In IE7, it seems to be doing what I...

Hi folks, The following query gives me a list of all field names and values associated with each listingsdb_id value in my table. SELECT r2.listingsdbelements_field_name as field, r2.listingsdbelements_field_value as value FROM default_en_listingsdbelements AS r1 INNER JOIN...

I'm working with a mysql table that includes columns field_name, field_value, and indexnumber. The indexnumber is common to all rows within a single record, one row per field. One of the fields is an agency code, and I want to find every row with that field, compare its value to my target, and...

I am trying to re-design a form that previously used radio buttons to filter the records displayed. I have removed all the filter code, but the modified form opens with no records displayed. However, if I select sort from the menu options, all records become visible and the modified form works...

When I request a web site (including this one), I often get two or three new windows with various ads. I don't seem to get them when I'm just sitting on a web site, but following a transmission I get these unsolicited windows. I'm on a cable connection and have a wireless router installed...

My organization uses a Netware 5.1 server and every desktop has either Access 2000 or XP installed. My unit maintains information that I would like to make available read-only to whoever needs it. The information changes constantly though, so ideally those users outside my unit could run a...

Is there a way to have Access supply the same sort of error handling code for event coding that is attached to a command button automatically by the wizard? I confess I don't always put in error handling code because I don't take the time to type it. It would be nice if I could just enter my...

I am trying to duplicate a paper form that has a number of checkboxes and descriptive statements inside a rectangle, all of which is in the report detail section. When the report runs, everything inside the rectangle is invisible. The same thing happens if I construct a rectangle out of...

I have a form whose recordsource is a table indexed on a numeric field where duplicates are possible. All records matching a given number are therefore grouped together in the table. My form has code that loops through a clone of the form recordset to find matching numbers and then writes...

I'm looking for the best (most efficient) way for my single record form to search a table, pop up a subform showing all relevant entries that the user could click to select the desired record, and then move to that individual record in the main form for either viewing or editing. Can anyone...

I'm looking for a way to identify an Access user without having that user sign into my application. Is it possible for the application to ID current user from the Netware login? Thanks. Jeff

Is it possible to display a report in a form window? I have a form from which users will select parameters that will result in a schedule. It would be nice if they could see the results in part of the form window and modify their criteria until they get what they want. I'm relatively new to...