While going through some SQL books I found that examples tend to use question marks (?) in their queries. What does it represent?
I am dissecting some code and came across this,   $sql = 'SELECT page.*, author.name AS author, updator.name AS updator '      . 'FROM '.TABLE_PREFIX.'page AS page '      . 'LEFT JOIN '.TABLE_PREFIX.'user AS author ON author.id = page.created_by_id '      . 'LEFT JOIN '.TABLE_PREFIX.'user AS updator ON updator.id = page.updated_by_id '      . 'WHERE slug = ? AND parent_id = ? AND (status_id='.Page::STATUS_REVIEWED.' OR status_id='.Page::STATUS_PUBLISHED.' OR status_id='.Page::STATUS_HIDDEN.')';   I am wondering what the "?" does in the WHERE statement.  Is it some sort of parameter holder?
Select an area in rep graph not working on Chrome The "select an area by dragging across the lower chart" thing is not working on Chrome.  Tested with Chrome 13.0.782.220 m, works with Firefox 6.0.1 and IE 8  Quirk: For some reason, if I open an incognito window, it works. Tried clearing the cache and cookies, still not working. Python scope: "UnboundLocalError: local variable 'c' referenced before assignment" E: Unable to correct problems, you have held broken packages Why is $\sqrt {12} = 2 \sqrt 3$? How do I use one shape to delete a portion of another shape? I have created an arrow shape (rightmost in image), from which I wish to cut out the majority so that only two thin sides remain. The most accurate way to do this would be to duplicate the shape and to somehow use the duplicate (leftmost in image) to remove the chunk that I no longer desire from the original. I am not sure what to do after the duplication, however, or if this method is even possible? Is there a better one? I need to set the text within a DIV element dynamically. What is the best, browser safe approach? I have prototypejs and scriptaculous available.  &lt;div id="panel"&gt;   &lt;div id="field_name"&gt;TEXT GOES HERE&lt;/div&gt; &lt;/div&gt;   Here's what the function will look like:  function showPanel(fieldName) {   var fieldNameElement = document.getElementById('field_name');   //Make replacement here } Who are the clients of my shared iTunes library? Is it possible to see who is currently connected and listening to a shared iTunes library? Is it possible to see which songs they listen to and how many/often?  It's not really important; I'm just curious about it. Would be nice to know which colleagues love my music… Getting nauseated from air travel, but it's not motion sickness... what to do? Google Chrome PPA upgrade invalid signature Why define an anonymous function and pass it jQuery as the argument? Shrink the database only up to its initial size which is set after creating database In SQL server every database has a property Initial Size (MB) which can be seen in properties of database in SSMS. By default it will be 3 MB for mdf and 1 MB for ldf file.  So now if create a new database then it will be set to default size(i.e 3 MB for mdf and 1 mb for ldf file). But after creating the database  I change the initial size to some other value say For mdf 10 MB and ldf 5 MB.(In real-time some database administrator may want to change initial after creating database)  But now if shrink the database it will shrink beyond the initial size I have set after creation(consider that no data is there in database otherwise it will shrink to its actual content size). It will shrink till the initial size it had during creation of database(i.e 3mb for mdf and 1 mb for ldf). I was expecting to shrink till the initial size which I have set(i.e 10 mb for mdf and 5mb for ldf). Can it be possible to do? If possible then how?  In some article i saw like dbcc SHRINKFILE can be used to shrink beyond initial size and dbcc SHRINKDATABASE cannot shrink beyond initial size. But I want to shrink only till the initial size to which I have set.  Note: I know that shrink is bad and should not be done.But I want to know how it can be done? If sql server considers only the initial size set during creation of database then what is the use of setting the initial size after creating database?  EDIT:  From microsoft shrink related article: Using DBCC SHRINKDATABASE you can not shrink database below its initial size.  My question is Can I change the initial size of existing database itself?  EDIT:  I have about 5 sql server instance. All the database where created with default size of 3 mb for data and 1 mb for log(about 3 years back). Now all the databases are in the range of 100-1000 mb. I wont shrink the database normally as it is not good practice. But some database grow more than 10 GB(mdf file itself as i insert so much data in it). So when database is large I will shift unimportant and old contents from this database to another server as it is not required in that server for me. So that database size reduces from 10 GB to 1 GB. Now the remaining 9 Gb left unused. Now I  want to specify database size to be reduced to 2 GB so that i will get 1 GB free space(Also 2 Gb is the ideal size for this database), Which can be used to avoid autogrowth till next 1 Gb of data is filled. Also i have set 100 MB auto-growth for this kind of large database which has more writes. So instead of specifying size as 2 GB in shrinkfile command,if it was possible to change initial size to 2 GB (which shrink considers) then it would have been better. During this database creation there was no plan about size ,autogroth etc. As it was created about 3 years back. Now i am planning to set autogrowth etc. I cant again create new database with new initial size and shift data. So I was asking whether I can change the Initial size for existing database? I have been reading about the new Salesforce async triggers. Currently, I tend to handle these sort of needs with a trigger that passes data to a 'Handler class' that would evaluate if a certain change has occurred. If it has then we pass those Ids to a queueable class for further processing.   What advantage do CDC and async triggers offer over using queueable or batch apex? 'setenv' command not working on tcsh shell when called explicitly I can run setenv command just fine in my tcsh shell like this:  echo $0 /usr/bin/tcsh echo $SHELL /usr/bin/tcsh setenv START_TIME `date +%s` echo $START_TIME 1499355967   But, whenever I run it explicitly like shown below, it doesn't work. I need to do this because I have to specify shell when executing it via python subprocess call, otherwise it will call a sh shell as default.  /usr/bin/tcsh -i -f -c 'setenv START_TIME `date +%s`' echo $START_TIME START_TIME: Undefined variable.   What's the problem here? I searched for this issue online, but couldn't find any issue similar to this. This is extremely frustrating. Annoying Viber notification What are the differences between "lay" and "lie"? I used the following code to list my java code, but the it looks like there's too much space between words. What can I do?  % source code listing \usepackage{listings} \usepackage{color} \usepackage{xcolor}  \usepackage{caption}  % citation style \usepackage{apacite} \DeclareCaptionFont{white}{\color{white}} \DeclareCaptionFormat{listing}{\colorbox{gray}{\parbox{\textwidth}{#1#2#3}}}  \begin{document} \begin{lstlisting}[label=some-code,caption=bind to service call] bindService(new Intent(this, Recognizer.class), recConnection, Context.BIND_AUTO_CREATE); \end{lstlisting} \end{document}   The snapshot of what I got. The code not completely shown, and space too wide, in function bindService. I have to design a circuit in which I have to transfer data through lasers (serial transmission of data). Now what I was thinking was to check if the laser light is on then '1' is passed and when the laser is off '0' would be passed. Now I need to check if a 1 or a 0 was passed.   How would I check for this and another problem I'm facing is if it's on it may keep on passing 1's. How would I check for this? I though of using LDR's (Light Dependent Resistors)? Would this be okay or it there a better method? Magic leaves "smudges" and a sorceress becomes a book I could use some help identifying a book I read some time in the last year or so. The book goes between two different stories:  1) A student of magic finds a book in a cave that turns out to be a person transformed into a book. The book talks to the student and they share thoughts. At some point, the student runs away, chase ensues, and at the very end of the book, he manages to travel to another plane.  2) A girl in a religious society where magic is forbidden. She is the daughter of painters. She discovers she can see magic. Falls in love with some random painter, risks performing magic to not be pregnant, does it again so she can, and is arrested and sent to some prison thing.  The common element between the stories is that magic use leaves behind a smudge of some kind that can be visible.  Any assistance is appreciated. Why doesn't the Related question list show that questions are closed? I saw a question on Meta that was obviously going to be a duplicate:        And indeed, looking at the "Related" questions list for that question showed a number of duplicates:    Being the good citizen I am, I tried to vote to close (technically Flag as duplicate as I've not got the rep here to vote to close) it as an Exact Duplicate only to find myself falling into a rabbit hole of Closed, Duplicate questions. Is there any way to flag a closed question as such in the Related list?  Mostly because the first one I picked was closed as a duplicate of the second one, which was closed as a duplicate of the one that is now listed as the duplicate/linked answer.   Edit to respond to comment:  I take the point about "not voting to close on title alone", and normally wouldn't, however as the questions had identical titles, and it's pretty clear what they should be asking, I clicked the first one:    which lead to:  which leads to:  - but I'd got bored following links and didn't check that one as the first two were identical, so assumed this was too and didn't want to see how deep the rabbit hole led.   In the related list, there's only one other question in there that is an exact duplicate, but hasn't (currently) been closed as such which is:      Reasoning for highlighting closed questions:  The "Questions with similar titles" does display the closed titles when asking the question, so it should be fairly possible to include.  If there are clearly duplicate titles, then as a reader/reviewer would be helpful to know which ones are already closed as duplicates so you can either:   Use the remaining open questions to focus on which of those is the canonical answer to close this with. Use the closed questions to find the canonical answer (which failed for me with my route of clicks). My office is a converted garage about 30 feet from my house.   I have a coaxial cable already running from my house to the office.   I want to attach a Ethernet cable from my DSL modem, in my office, to a computer in my house.   Since I already have the coaxial cable installed, I bought two coax to Ethernet converters (NVA-P-860-BP78 Video Balun), but when I hooked them up I am getting no signal. It was my understanding that an Ethernet signal could travel over a coaxial cable.   Is that wrong? Any ideas why this isn't working?