c# - SQL statement fails -


i use statement:

  select threadsid     threads  order threadsid desc

why sql statement fail return i'd expect? reason, puts 1 record id = 32 between id = 52 , id = 53:

threadid --------- ... 53 32  -- <-- huh?! 52

connection string:

    <add name="modelconnectionstring" connectionstring="data source=.\sqlexpress;attachdbfilename='d:\documents , settings\dima\my documents\visual studio 2010\websites\website10\app_data\aspnetdb.mdf';integrated security=true;user instance=true;trusted_connection=yes;"   providername="system.data.sqlclient" /

i have got additional info effects list:

    stringbuilder sb = new stringbuilder();     sb.append("select u.name,t.threadtitle,t.date, t.views,t.replies,p.theme,p.topics,t.pagenumber, t.threadsid");     sb.append("  threads t");     sb.append( " inner join users u on u.usersid=t.usersid");     sb.append( " inner join topics p on p.topicsid=t.topicsid");     sb.append(" t.threadsid=@threadsid");

the @threadsid..goes second query...but doesnt effect order of things.. after both of seperate sql commands executed weird result

it because id not number type. kind of data threadid on table?


Comments

Post a Comment

Popular posts from this blog

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

php cli reading files and how to fix it? -

while using php cli in ubuntu got apache web server cant read file can while using in browser. , error shows nothing , next used code testing purposes : <? $handle = fopen("testfile.txt", "r"); if ($handle) { while (($buffer = fgets($handle, 4096)) !== false) { echo $buffer; } if (!feof($handle)) { echo "error: unexpected fgets() fail\n"; } if(!is_readable($handle) { die("not readable"); } fclose($handle); } ?> how fix ? edit : after removing '@' before fopen got following error fopen(testfile.txt): failed open stream: no such file or directory in /var/www/log/ka.php on line 2 when run script through cli, uses shell's working directory, in opposition file's directory (which apache hands current directory). important you, since fopen call depends on relative path; , relative paths resolved relatively working directory, not script. to have script behave apache, eit...
Read more