Many senior executives of businesses that rely on custom software - within their products or underpinning their company's services - seem to tolerate or avoid tackling long standing dysfunctionalities in the projects and teams developing that software. In your personal experience, why should this be so? ...
I need to display many pages of news in a site. Should i do the pagination in the db query using limit or do it in my php script after getting all the results? ...
I am using the "MySQL C API" to query the database and I have the results stored in MYSQL_ROW types. I am able to use print the results to the console with printf("%s", row[0]), however, according to the MySQL C API documentation, I cannot use them as null-terminated strings. At the bottom of http://dev.mysql.com/doc/refman/5.0/en/c-ap...
I need a "result server" that can store my raw test data (server cpu, memory usage, etc), create report template (e.g. user number vs response time), generate live-reports base on templates, and perform complicated analysis (such as 70/80/90 percentile charts, data distribution comparison between test, etc.) ...
hi, sorry for my previous question which was very ambiguous, but i think if i get the answer to this question I can work it out. In the program below i have selected the barcodes of products where the amount is less than the quantity. I want to say, that if the barcodes(in the fridge table) match barcodes in another table(products), set ...
This is my first time posting - I greatly appreciate any and all guidance on this subject. Background: I am building a Real Estate web site. I would like to use the free IDX data provided by my local MLS board. The MLS board does not allow me the option of displaying a predefined search and only provides me with a link to the search fi...
I currently have a stored procedure that returns a list of account numbers and associated details. The result set may contain multiple entries for the same account number. I also want to get some aggregate information such as how many distinct accounts are contained within a particular result set. Is there some way to retrieve such a vie...
What's the best way to implement "Back to Search Results" in an ASP.NET application? I've been letting users do the BACK button in the browser, but they always get a prompt to resubmit the form. Is there an effective way to work around this resubmit? Should I cache the search criteria/url in session and redirect them when they press '...
Hi, can anyone tell me, how to retrieve joined result from multiple tables in cakePHP ( using cakePHP mvc architecture). For example, I have three tables to join (tbl_topics, tbl_items, tbl_votes. Their relationship is defined as following: a topic can have many items and an item can have many votes. Now I want to retrieve a list of topi...
The following code continues to be displayed even if there are entries in my database and I don't understand why. Am I missing something? I'm not sure if this makes sense, but help would be great. :) if($numrows==0) { echo"<h3>Results</h3>"; echo"<p>Sorry, your search: "".$escaped."" returned zero results</p>"; } ...
I'm pretty sure I've seen this somewhere, but I can't find the right terminology so I'm having trouble... Let's say I have a table with user info (let's also assume that it was created by someone who gets paid more than me, so modifying the schema is not an option.) Among the various columns of user info are columns for DOB and job titl...
Why would the following queries return different result sets? select count(ml.link_type),mc.conv_string from MSP_CONVERSIONS mc,MSP_LINKS ml where ml.PROJ_ID = 4 and mc.STRING_TYPE_ID = 3 and mc.CONV_VALUE *= ml.link_type group by mc.conv_string select count(ml.link_type),mc.conv_string from MSP_CONVERSIONS mc left outer join MSP_LINKS...
For example, if I profile: C:\Program Files\Application Build 1\MyApp.exe C:\Program Files\Application Build 2\MyApp.exe And I then import both sets of results into a single AQTime project and attempt to compare them, AQTime doesn't match up any of the corresponding functions in each. I'm assuming that while it's comparing, when it com...
Hello. I'm generating JSON response from PHP witch looks like this: { done:'1', options: [{ message:'Example message'},{message:'This is the 2nd example message'}]} I want to grab these results using ExtJS. This is what I have so far: Ext.Ajax.request({ loadMask: true, url: 'myfile.php', params: {id: "1"} }); What d...
Hi, I'm working on source code analysis of the linux Kernel considering all the 2.6 versions... I'm collecting results for each file compiled and for each version of the kernel... So far, i'm using an ad-hoc format and then I analyze the data with a small python script (a typical result file is about 300MB)... However, an ad-hoc is ...
Hi guys. I will re-write my doubt to be more easy to understand. I have one table named SeqNumbers that have only one collumn of data named PossibleNumbers, that has value from 1 to 10.000. Then I have another Table named Terminals and one of the collumns have the serial numbers of the terminals. What I want is get all the SerialNumbers ...
Hi all, I have a mysql query which spits out the following: Array ( [0] => stdClass Object ( [bid] => 18 [name] => Cafe Domingo [imageurl] => sp_domingo.gif [clickurl] => # ) [1] => stdClass Object ( [bid] => 19 [name] => Industrial ...
I'm using CruiseControl.NET with NUnit and NAnt. I'm trying to get CC.net to send out emails that contain the styled test results and build information. My config file looks like this: <publishers> <merge> <files> <file>C:\Tests\*Results*.xml</file> <file>C:\Artifacts\*</file> </files> </merge> <xmllogger logDir="C:\...
I've tried every avenue on every damn forum suggested, but to no avail! Need to send results of SQLPERF(logspace), that have been stored in a table, via sp_send_dbmail to recipient. Step 2 of job is where failure occurs. Please help! EXEC msdb.dbo.sp_send_dbmail @profile_name= 'MyDBA', @recipients= '[email protected]', @subject='Log War...
Hi, my questions pertain to class objects defined for mysql/php interface: Which of the following method is best from a design point and why (relative advantages/disadvantages to each other): To use a single class like ezSQL towards abstracting the mysql/php interface? To use a combination of a DB Connection Class and a Results Class...