Found about 111 opinions about Querys like [forms]![frmSearchProducts]![ProductSearch].
(Page 1)
1.
PHP & Mysql updating many to many relationship with checkbox form
(23 Apr 2009)
I have a many to many table structure and updating checkbox forms.
The goal is to relate the users table to the projects table with the users_project table. This way there can be many users per project and many projects per user.
The form would on each user edit page would look something like this
<form action="#" method="post"> <div> <input type="checkbox" name="project_id[]" id="1" value="1"> <label for="1">project 1</label> <br> <input type="checkbox" na...
2.
Comparing Form Entry To Db On The Fly - Options?
(29 May 2009)
I'm working on an Intranet site for a client, a part of which is entering new customer details.
They have asked if they can have the app compare a new postcode against exiting matches in the DB as it's typed, and should a duplicate postcode be entered then they be shown the details and given the choice to use the existing record or continue with creating a new one. (hopefully that makes sense?)
I can see 3 choices on how to do this but each has some down sides and I was hoping for second opinion...
3.
Creating a Continuous Form that Continues Horizontally as well as Vertically...
(19 May 2009)
Hello all,
I'm planning a database to allow the storage and retrieval of product information. Each product is to have an image associated with it, by saving the path to the image into a designated field. I would like to display these images in with the search results on screen, so that the users can find what they are looking for at a glance. I have managed to get this to work in a little test DB I created in Access 2007 by linking the field containing the path of the image to the control source...
4.
I rate myself as a bowler first... Afridi answers readers' queries
(10 Jun 2009)
Shahid Afridi
'I rate myself as a bowler first'
The Pakistan allrounder answers readers' queries about his preferred batting position, playing against India, his biggest six, and more
June 10, 2009
1. Who is the most difficult bowler you ever faced? asked Fezzan from Sri Lanka
When it comes to the new ball, it was Glenn McGrath, while with the spinners it is Muttiah Muralitharan. McGrath was obviously due to his accuracy, whereas Murali is a very difficult opponent, especially on subcontinent pi...
5.
Query
(17 Jun 2009)
This is mod bashing now?
I'm not questioning moderation (because that would get me banned), or wish to incite discussion (because that would get me banned), or question the logic behind a moderator decision (because that would get me banned) or expect fair treatment as a contributing and respected community member (because that would get me banned) or demand an explanation (because that would get me banned) or be disrespectful (because that would get me banned) or discuss politics (because that...
6.
Introductions and Queries
(21 May 2009)
I have played before, but due to various circumstances moved on. We (my wife and I) initially played on the US server of Elendilmir to the cap (and had alts in the mid 40s, and 5 grandmastered tradeskills), but moved to Sofia, Bulgaria back in January of 2008. We picked up the Euro versions (couldn't transfer US toons to Euro servers) and played briefly last year, long enough to level up a captain and minstrel to 45 on Snowbourn, as well as a couple of alts to 38 and 42, I believe (been awhile s...
7.
Modern Mythologies as God Forms
(11 May 2009)
I've gotten positive results from utilizing aspects of modern and pop culture mythology to replace what some might consider to be antiquated deities. For example, say at a Summer Solstice. People may want to use a sun god such as Apollo or Luh. Throwing established ideas out the door, I used Superman instead. Yes, I know it sounds odd. However, in the public's mind, Superman has taken a sort of mythical status. In addition, I know exactly what Superman looks like where Apollo is open to interpr...
8.
Submitting to O (Oprah) Magazine?
(25 May 2009)
So I'm pitching an article to O Magazine and I have my query all written.
I cancelled my sub to Writer's Market online when the site went down for more than a week-- and I doubt they are listed in there anyway.
Anyone have the best e-mail contact info for freelance submissions?
What are your opinions on using the "plug form" on the Web site, which actually does look like a place to query?
I want to note I'm not being lazy -- been surfing the Web for a while and doing my own research, too. I thin...
9.
Splitting one table in to multiple tables- how to move the data afterwards...
(22 May 2009)
Hi all,
I was wondering if I could get your opinion/advice on this situation. Hopefully someone knows the answer to my question below
Database information:
Table 1 has 20 columns and about 10k rows of data. The database is expected to grow to 30-50k entries in the next couple years. This is currently the only table in the database.
How data is currently being transferred to the database:
We use a macro that scans a folder for excel files. If there's an excel file, it automatically appends it to...
10.
JPA handles ManyToMany very inefficient... or am I wrong?
(27 Apr 2009)
Ok, here is may problem...
Take the @ManyToMany example form jee5 javadoc:
In Customer class:
@ManyToMany @JoinTable(name= "CUST_PHONES" ) public Set getPhones() { return phones; }
In PhoneNumber class:
@ManyToMany(mappedBy= "phones" ) public Set getCustomers() { return customers; }
Now say that you want to add another phone number to a customer:
The method would look like this:
void associatePhone(PhoneNumber nr) { getPhones().add(nr); nr.getCustomers.add( this ); }
The customers and phones...