Search results for query: *

Hi Guys, this is a tough one, for me... I'm working on a ecommerce db migration, this is the basic structure : description price image category subcategory1 subcategory2 subcategory3 subcategory4 subcategory5 There are 8,000 records, 6,000 of which are same items present in different...

Hi, How can I populate an array so that i could use it this way : echo $client->name echo $client->phone etc etc ?? The array will be populated manually. Thanks !! -- PG

Hi Guys, I have a large (50 million records) demographic table, normalized, with about 10 searcheable fields (annual income, number of children, etc etc) all searchable fields are id's related to smaller tables. The query I will run against the db is a classic multiple options choice : Income...

Hi guys, Can somebody help me transform this subquery in a prior 4.1 version ? SELECT name, contact FROM contact WHERE contact NOT IN ( SELECT contact FROM contact_to_students WHERE student = whatever_id ) Appreciate the help ! -- PG

I have two tables : students and contacts Contacts can be related to several students and viceversa I'm trying to come up with a select (prior 4.1) that will allow me to choose a contact which is not related to a particular student, but also not related to any other student. Contact table...

Hi guys, I know this sound trivial, but I cannot find a way to do this simple task. I have a form which is repeated in various pages with different values, and only one text field. In the same page (php) the same form is double, with a different name in case it is an update or a add action in...

Hi Guys, I have this situation : Period1 (mandatory) Period2 (optional) Period1Available (T/F) Period2Available (T/F) I would like to display in a form : 1. No periods available 2. Period1 and Period2 in a select if both exists and are available 3. Period1 if Period1 is available and Period2...

Hi guys, I have a form where the user can multiple check various options (medical specialities) dynamically created from a table, and eventually in a later moment edit the choices adding or unchecking options. These options are not fixed, meaninig that the number of possible choices can grow or...

Hi Guys, Does anybody have a function ready to parse all forbidden SQL characters for an insert/update statement ? (like single quote, %, &, ect..) I know, I'm lazy ! :-)

Hi guys, I have a project with like 50 tables that have to be initialized, hence I will have to prepare a basic form (add/edit/delete) for each one of them.... You all know how boring and time consuming that process is, so I'm wondering if there's anybody who came up with a sort of 'wizard' to...

Does anybody knows a BB designed to host sponsored banners ? I would like to present one or more banenr everytime the user reads/writes a message ... Thanks -- PG

I have a table where I have to refer to the column names through some varibales. Everything works fine for almost everything (yeah, almost is alway the problem...) but when i try to use the variable name to perform a calculation, i get a type mismatch error, meaning that the statement is...

Hi, I'm using the famous date-picker.js for one of my pages, where I have 2 form fields with dates to be picked-up. My goal is to assign to a third form field the day difference between the two dates. I've tried to trigger the function from an 'onchange' event, but the date-picker assigns the...

I have this application I'm starting to work with, with a lot (50) basic tables that need to be browsed, edited, added, deleted.. I was wondering, is there anything that automates the process of creating all the forms/views exists ?? I know that i could write some code for this purpose, but if...

Hi guys, I'm in the analisys phase of a new application, a reservation system for the travel industry (SQL Server as db), and I need your suggestions on what would be the most efficient approach to the following situation : Tipically, most services related to leisure travel have different...

I tried to search the threads to find an answer, but i'm confused.. I'm using fp 2.6 dos, and i'd like to know if it's possible to use a SQL database server (MySQl, Interbase, etc) instead of dbf's. Is ODBC working with dos versions of fp ? Thanks Pierluigi Ferro

Anybody knows if it's possible to change the row color of a browse window depending of its content ? (eg if a certain field has a negative value, row appears with red foreground) Thanks

Is there a way to pass a variable to a SQL 7 Trigger ?