Need help with a sql statement used to select a specific address. For example I have a database named musickey_TESTER, and a table named PERMITMASTER. I would like to select an exact record from the ADDRESS field. i.e 509 BERRY CT. I have tried many statements but can only get it to work searching on the address number.
This produces no results however when I input just the numeric part of the address it will return any address with that number in the string.
It is helpful to post the SQL you have tried, and what the results are compared to what you are expecting.
Thanks for taking a look. Yes I have tried that. The $search in the statement is tied to a user defined form field.
I don't work with MySQL much, or PHP at all, but I work with other SQL variants a fair amount. Are you sure your variable substitution is correct? To me, it looks like you are searching on $search, the actual text, and not the value behind the variable. What about if you change the SQL line to read:
Also, what about capitalization? You could UCASE both the search condition and field values to eliminate any case sensitivity.
Just to add a little more to @JoshuaBixby's reply. Instead of "+" sign use "." which is used for string concatenation in php.
Thanks you guys very much for taking a look! I modified Joshua Bixby statement to include your recommendations.
I still get no results when entering 509 BERRY CT. However I can search BERRY CT and get results. It appears to be the the space after the numeric value in the address that is bombing it?
I've tested through your page. Right now what is happening is that the query is kind of looking for the whole term "509 BERRY CT" but trying to maintain the position of each word within it. Instead if we break this whole term into words and send to the query it will return the results wherever it finds each word regardless of its position. So in your backend page check for spaces for the input and substitute those with "%" and send to query.
Thanks for the reply Mir! We are so close. Is there a way the user can enter a literal string 509 BERRY CT in the search without having to enter a wildcard?
$search = "509 BERRY CT"; changed to $search=$_POST['search']; in order for the user defined form entry to work.
The Graphic I want to add is a circle(polygon) where the center is an attribute value from layerQuery and the radius the value entered by the end user.
Before you call your AddGraphicToMap procedure you need to convert your XY to a Point then use the ITopolocalOperator.Buffer method to create your circle. This would become your geometry that you pass to the procedure.
I'm just learning ArcObject in ArcGIS 9.2, find attached a copy of my customization. Please can anyone help me with this, i have a shapefile layer called State_LGA.shp with attributes which has fields STATENAME, LGA, Population, TB, Malaria etc. i want a situation where by i pick a state from the state combo box to generate the LGA records for each state in the STATENAME and if I click population command button, it will show the population value of the LGA i choose for the state.i.e
population = 122333 (clicking the command button, the population value in the population field for Kuje LGA will come out). I have customized a form which is attached as Training for more clarity. i believe with this i should be able to work on other command (Service availabily etc.) Please help me with the codes, am a novice, i will appreciate if someone can spoon feed me on all the processes. thanks in advance.
Radix2309, I'm hoping big-time for the same thing. I hope that FFG doubles down on the viability of the LCG!
Yes, Ersatz I feel very excited for the reprint of VTES! Do you feel like the gameplay needs any tweaks? Also, I don't know, Radix, I feel like FFG could drop a game a couple of weeks prior to Gen Con to get that draw-drop, instant-buzz effect, like, "FFG announces Dune LCG!"
Hey-O Everyone! As we saw the Star Wars and Android: Netrunner games leave town this year, I feel a real need in my gamer soul for a new, jam-packed L.C.G. As far as I know, FFG hasn't announced anything debuting at Gen Con. The past helps me induce that the company will have something new and amazing in their hands at the convention. What do you all think they will debut at Gen Con? As for me personally, I cannot talk myself into investing in a blind-purchase,booster-pack, collectible, card game. However, I'd get in line for a well-playing, living card game.
LCG success breaks down as: FFG designs a quality LCG. Thousands and thousands of players buy in. FFG makes enough money from the game to allow the sorted booster packs to continue.
We have got to get more LCGs because it opens up the gameplay space to people who want to enjoy card-based decision making, without hearing about how, "This card costs $.50, and this card costs $44." Also, players having the exact same pool of cards to draw from really demonstrates that you are competing on an even playing field between newbies and veterans. For example, during one of my very first games of Netrunner on Jinteki dot net, I ran like my pants caught fire and pulled enough agendas from HQ to win on turn two, while my veteran opponent screamed that I played the game incorrectly by not setting up first. Sure, that game qualifies as a total fluke, but I had equal footing with that other more experienced player. FFG has got to keep the LCG fires burning.
Hello, I would like to suggest that they create Conquest 2.0 with The Twilight Imperium Universe. It couldn't get any more Fantasy Flight than really making every detail of that world come alive. They could include about six races in the core box and a new race in each deluxe expansion. FFG people, make this happen! You know you want to!
Oh, Man, I care about FFG and their goals in providing tabletop-gaming excellence. I hoped for a homerun, not for them to fall over. And yes, early L5R had multiple first-turn win conditions. Those people had no idea what game design meant. Haha
Hello, Thank you for the views and posts to this discussion. Please allow me to add: when designers restrict cards, they admit that they have over-powered a card or not caught how it interacts with other plays in the game. I wish that they would raise the cost or lower the effect of restricted cards and then reprint them for free in a future expansion rather than allowing the players to use only some of the cards they bought. Also, in gameplay, one player draws and uses a restricted card, while their opponent's deck fails to produce the over-powered, restricted card she needs to play. Furthermore, in the old L5R, the publisher would nerf cards just as they came out, so I would open a pack and see a cool card. Then, another player would tell me to go online to see how that card works now. I feel very sad that we can't update cards like we can computer games. I feel very excited for the L5R roleplaying game on the way and hope that it affords us the ability to experience Rokugan.
Hello, Thank you all for viewing and responding to this post. Both previous posters commented that I may have added this discussion to the incorrect forum. I felt that talking about cards and rules of the game most closely represented my views on the loss of evergreen abilities from Old L5R, rather than discussing the lore or specific, gaming groups. I lament that the designers have chosen to lose some of the keywords that really helped bring out the flavor of Old L5R. For example, battling a Spider Clan deck of fear-inducing characters allowed me to bravely defend my homeland as a strong Crab Clan.
Hey, Everybody! When I saw the first notes on FFG's webpage that they would re-tool and release L5R, I thought about how they should keep 95% of A.E.G.'s game in-tact. I played old L.5.R. for years. The game had a couple of problems, like the Cavalry keyword made for completely jank combats, but when that big battle finally happened, it produced truly, truly cinematic moments better than all of the movies playing on theater screens. A Dragon invasion squad attacks a province and the Lion volley back with their arrows, blades, and tactics cards. Wow! I checked FFG's webpage every day, like a devout, religious follower, waiting to see a preview of the game. Then, last year, when the first preview dropped, I felt like the FFG designers created a different game, that widened the asymetrical issues of L5R, like a political-heavy deck not interacting with a military-heavy deck. Then, I saw the designers talk with the boys at Team Covenant and realized that they just threw some ideas into this world, like seven economic points to spend each turn and wonky cards with semi-tricky abilities. After reading all of the previews and watching all of the videos, I felt like I couldn't trust the designers to really deliver on this game experience and thought that once a real player-base got their teeth into this LCG, its design flaws would rip open. Now, here we are six packs in, and here's the unfortunate inevitability, a huge restricted list and an admission that the crew at FFG are learning on the job rather than delivering a top-shelf game. I passed on their L5R game when it came out and feel glad that I did. I completely dig FFG's production values, artwork, graphic design, and intellectual properties. I just really, really, really wish that they would take the time to develop a more straight-forward, faster playing LCG that could act as a gateway for new players and have the rock-solid gameplay that veterans like me can appreciate. How does everyone else feel about the revisions on the go for L5R?
Yes, I'm hoping for a resurgence in the game without complexity getting in the way. I would love to walk into a game store and see twenty people playing.
That makes a lot of sense, designers initially asking the question, "How do we make the game experience better rather than how do evolve the gameplay into something deeper," like asking, "How do we make a better Star Wars film," instead of, "Where do we take the Star Wars universe?" But this paradigm of game making does seem to imply a reachable limit of what cards can be made before power creep or brokenness occurs. I hope this new cycle resets us all back to good games on the table.
Hey-O, Everyone! I want to ask the experienced players how they feel about the new restricted and removed list for ANR? Do you all feel that it ultimately helps the game move forward, or does this more indicate serious problems in the development teams? Thanks!
Can someone clarify - I have a master table for lets say products in my case (Tours) are my products - When I try to establish a relation lets say
Then if I try to establish a second relation from tours ID to fk on a joint table - It creates a table occurrance of the tours table - Tours 2 - Is this table the same as the master table and does this mean that all changes I make on the master table will show up on the tours table.
A table occurrence can be seen as a "virtual table." You interact with one just as though it is a distinct table. However, when you double click a table occurrence in their relationship map, you'll see that it refers to an actual table that may in fact be the same table as any number of other TO's in your graph. Thus, if you use a script or layout to modify the data through a specific TO, all other TO's that have the same data source (actual table) will receive the same changes.
TO's allow you to create multiple, different relationships between the same two tables. As each relationship matches different pairs of fields, each relationship will give you the ability to work with your data in different ways as determined by the relationship that links them. Thus, the relationship you design will determine which TO you refer to in your layouts or scripts.
You can even create two TO's for the same table and then create a relationship between them! This is called a "self join" and can be a very useful tool in many cases.
"When I establish the value lists - Do I go from the master tour table or the Tours2 Table?" If you are simply specifying that the values come from a specific field in your table, then any TO in your relationships graph that has the same data source will give you the same list of values. There is an option in your valuelist setup dialog box that lets you specify "related values". If you use this option, you can create value lists of different values for different records based on their relationship to the TO you specified. Now it can make difference which TO you refer to because they likely have different relationships.
Oh, Facebook....if you're wondering why I'm over here by myself in my own community, read this thread about the epic breach that happened today. Via Mike Isaac, Tech reporter for the NYT: "one thing important to understand: it's much worse than just a straight up data breach. Hackers had *complete and full control* over 50 million user accounts for an indeterminate amount of time. no hyperbole: This is probably their most serious security issue to date." Still think it's the best place to have your community live? | Mizz Information
I am trying to download application from RAppID boot loader for MPC5777C but download process not ending, Please check below process and attached image suggest me what went wrong
We are using imx6 Dual Lite with kernel 4.1.15, with custom yocto meta layer and on a custom board, that was prototyped from the imx6 wandboard.
On the board we also have UART2 connected to MAX3232 UART to RS232 transceiver, and RS232 connects to the lap top USB. (I need to make this output default console output)
I have connected oscilloscope to RTS/CTS/RX/TX pins and nothing happens when i try writing to the ttymxc1 port, they just stay in 'high' state.
I have repeated steps above with following configuration (without any flow control) as well, but i get same results
From the questions i have already browsed here, people seem to have a problem with CTS/RTS lines swapped, but since i've disabled them it shouldn't make any difference.
Ughh it's embarassing, but it's actually just a typo (that's also in the question) that wasn't caught by the compiler, and got me pulling my hair for the whole day, apologise for the inconvenience.....
I try restart my discovery loop with NxpNci_StartDiscovery() some seconds after I called NxpNci_StopDiscovery().
problem fixed. it was an issue with dma and cortex M7 data cache, i2c and SDIO use DMA cacheable memory zone. problem of concurrent access.
While setting value in Tos register, I am writing the value, reading back and verifying if both (written value and read-back value) are same.
This delay is not normal, it is probably caused because of the capacitance of the I2C bus or the pull/up values, but if you found that adding a 1ms delay works as a workaround, you can use that for your system.
I then click Unread Posts to pick the next in the list and there are none....the Unread Posts page is empty.
Isn't this because the first display is recent unread posts and after appearing on a list they are no longer recent? So you need to select all unread posts to see them.
Yes, you are right. I've just experimented using Chrome on my Nexus 7 and reading a single post from the unread posts list, then selecting unread posts again returns the same list (apart from the one I've just read). No need to select the all unread topics option.
That's what Safari on my Mac does for me; is that not the way it's meant to work, well it has for me since I joined these Fora. i.e. You've read an article so when the list is refreshed there is one less.
That is very weird, what does the link say it is when you hover over the "UNREAD POST" link above? Mine says http://community.plus.net/forum/index.php?action=unread
Copy and paste that into your clip board then the next time you read an entry from the the list paste it into your address bar and see if the list returns minus the article you've just read or empty.
Surely what has / has not been read is held server side against the user profile. To do otherwise would mean that on moving to another device, details of what has been read elsewhere could not be known on the second device.
Can I please get a new router as mine is the original Thomson one I received when I joined Plusnet in 2011 and the only room I can get wifi is the living room where it is sitting the rest of the flat is a deadzone, very annoying!! Even then the wifi drops out while I'm looking at it and the speed is dead slow and can take ages for a page to load.
Are there specific routers that work with plusnet broadband or can I just buy any from ebay or somewhere?
A good list of FTTC modem/routers is found at http://forum.kitz.co.uk/index.php/topic,14436.0.html which also includes a discussion about them.
There is nothing special about Plusnet's own devices if you take into account the above. You are free to use your own device.
If I'm looking at the proper Presentation, it appears that there are several Spreadsheet Gadgets in use. The leftmost one is set to scroll, the other 3 are not.
If all the data can fit inside the Placeholder, then there would be no scrolling regardless of how the Gadget is set. Once you add additional rows, you may come across a situation where not all the rows fit in the Placeholder and as a result, the data will scroll (as long as scrolling is enabled).
I noticed that there aren't any Displays listed in this company. Are they just using Previews to view the Presentation? They may be using a different browser than what you're using (we do recommend the latest version of Chrome). Its also possible that the browser they are using has has it set so that the font appears larger.
I am having issues with their display as well. i had to use the browser options to zoom the display and even then it doesn't quite fill the screen correctly.
Another issue is the screen not fitting the ration . The Flat screen is a Revolution 46" LCD which the specs say has a max resolution of 1366 x 768 so that's what we have the presentation designed to. But it seems to not fit appropriately. Is this a software issue or the NOW Micro media player issue? Any advice on how to address it ?
Can you confirm that the computer has the desktop set to 1366x768? I'm not seeing any Displays listed for the company. Are you just using the Preview in a browser?
I will be at the site this afternoon. I believe you are correct and that we are just viewing the presentation in a browser. I believe we will need to install the Rise Vision Player before we go any further . Correct?
I’m selfish and rude bc I told grandmas to call or text if they want to stop in. Not only that but -
-Was one of the lines I got in this big long email about how not letting my mom or MIL drop in any time they want was making me into a bad mom...
I’m so tired of the gas lightning. They act like they are entitled to my baby girl any time they want, waking her up from naps and or overstimulating her with how loud they are...
You are not being rude or unreasonable, the grandmas are! How old is baby? My MIL was this way when my DS was a baby, but early on we established and consistently enforced boundaries, and with time she became much more considerate and learned to just appreciate the time she got to have with him. It did take a couple of years though!
Stick to your guns!! There were many times that I spent the day in my nursing pjs on a recliner and wanted nothing more than to nurse and sleep. I would have been super pissed off if people just dropped by. Basic manners don't stop just because there's a baby. It's important to have these boundaries.. and when they push, skip a week. Let them know that it won't be like this forever, but right now this is what you need and anyone that's not on board will be cast off for a week until they can respect your wishes. Stay strong, momma!!
I was laying in the hospital bed right after my son was born doing skin to skin and my mother walks in and says she wants to hold him. I told her I needed to do skin to skin. She called me selfish. To this day 8 weeks later she still says I was being selfish. Because I wanted to hold the baby I just labored 27 hours for and had a c section for. Me selfish. ***!
Stick to your guns. You’re not selfish or unreasonable. You didn’t have a baby for them to get all goo goo eyed over. Baby, is not a toy or hot commodity. You need your time and baby doesn’t need to be over stimulated!
just let them know that if they come over unannounced you may not open the door because you and or baby are sleeping. If baby is sleeping, baby will continue sleeping even if they are still there. they have to SEE why it's important to call or text before coming over. stress that some times it's not always a good moment to visit. I hate having to entertain people when I'm tired and just wanted a chill day.
I made a post about this the other day. I have the same rule and some people find it rude but I don’t care lol. Anyone that wants to come by needs to make sure it’s okay first. I don’t allow drop bys and I won’t answer the door.
Ugh. I’ll be in the same boat. I hate when people just drop by. It’ll infuriate me as a new mom. I swear I’ll just not answer my door unless I’m expecting a delivery lol
I feel like my mom would say something like this. Thank God no family will be near the hospital for this baby
We tinted the window on our front door for this reason. It’s just a small window but now no one can see in if they do drop by, I always keep it locked and whenever I’m not expecting people, I don’t answer the door haha
When my now 3y/o was a baby, my in laws felt they could do this. During a particularly rough week, I denied them entry (I needed to nap before work)and my FILs comment was ‘I’ve never needed an appointment to see my family’ and they left in a huff. That evening, my DH went to see if he could go for coffee and MIL told him FIL was in bed so he replied ‘well, I’ve never needed an appointment before’, made a dramatic huffy scene and left. They got the point LOL
Yeah I got the “I guess I have to make an appointment to see my granddaughter!”. But in reality it’s not an appointment that needs to be made, it’s what we once used to refer to as “plans”. What ever happened to that?? Once DD was born I guess that flew out the efing window!