IssueManager 3.0
IssueManager Enhanced 3.0
VCalendar

News 
Issue Manager Enhanced to be included with CodeCharge Studio 10/28/2007

Subscribe
for notifications about new releases
(of all our apps)
Email


Wordpress themes


Design awesome Wordpress
themes & professional
Website templates.
www.Artisteer.com

Problem with SQL Server
Author Mike Quigley Posting date 10/4/2001 9:43:53 PM
I am running IIS 5.0 on a Web Server and SQL 7.0 on a separate DB Server. I installed the ASP, etc. files and created the SQL DB from the script and created a DSN on the Web Server. After I login and the app tries to run default.asp, I recieve some ODBC errors.

I had to go into default.asp and modify the base SQL statement as follows:

sSQL = "SELECT status, Count(issue_id) AS issue_id FROM statuses, issues WHERE statuses.status_id = issues.status_id"
sOrder = " GROUP BY statuses.status;"

The s & i variables would work if I pasted the statement into the SQL Query Analyzer, but the code would not run from IIS. I was getting an ODBC error "Invalid column name s.status_id".

Now I am stuck on the Summary Open Event Code. If I replace the code as follows, I still get the invalid column name error:

sWhere = replace(sWhere, "sstatus_id", "statuses.status_id")

I tried to comment out that line just to see what would happen next and it stops on the 'sWhere = sWhere & "[sstatus_id]=" & pstatus_id' line when trying to build the where clause.

The full error message is:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sstatus_id'.
/Common.asp, line 36

Seems to me that the app is having a hard time handling some of the db variables. Any ideas?


 

Replies
Re: Problem with SQL Server 
Author Mike Quigley  Posting date 10/4/2001 9:49:06 PM 
I forgot to add that I can run all of the Admin functions fine including adding, editing, and deleting users, statuses, and priorities. I can also add issue without problems. The only problems seems to be displaying the issue list. 
Re: Problem with SQL Server 
Author UltraApps  Posting date 10/5/2001 12:53:12 AM 
It's hard to tell what's wrong, or if possibly your changes may be afffecting the overall logic.
I recommend using following debug method to get more insight into this issue:
Modify Common.asp by adding an additional line after "sub openrs(rs, sql)" like this:
response.write(sql & ":<br>")

This command will display all executed queries, which should tell you more about what's wrong with the SQL.
Once you do this, you may be able to solve your problem, or please let us know the SQL that is being executed.

BTW, the code for ASP version 1.1 was tested with MS SQL 7.0 under IIS on Windows NT 4.0.
I'm wondering if maybe the SQL script wasn't created correctly, or else I don't know why it would work.

Regards,

Robert
 
Re: Problem with SQL Server 
Author UltraApps  Posting date 10/9/2001 4:07:13 AM 
Thanks!
I remember fixing this before, but somehow it didn't make it to the release 1.1
We just updated Issue Manager to version 1.2 (with just this one fix)

Robert
 
Re: Problem with SQL Server 
Author Bert  Posting date 10/21/2011 5:36:52 PM 
One or two to remmeebr, that is. 
Re: Problem with SQL Server 
Author Kiana  Posting date 10/22/2011 2:45:24 AM 
I had no idea how to approach this before-now I'm lcoekd and loaded. 
Re: Problem with SQL Server 
Author Janaye  Posting date 10/22/2011 10:21:54 AM 
That's a mold-breaekr. Great thinking! 
Re: Problem with SQL Server 
Author Jock  Posting date 10/23/2011 7:28:08 PM 
You mean I don't have to pay for expert avidce like this anymore?! 
Re: Problem with SQL Server 
Author Xandy  Posting date 11/12/2011 1:36:59 AM 
HHIS I shulod have thought of that! 
Re: Problem with SQL Server 
Author Mina  Posting date 1/8/2012 4:53:22 AM 
Hey, you're the goto expert. Thanks for hnagnig out here. 
Re: Problem with SQL Server 
Author Iyke  Posting date 2/17/2012 11:22:21 AM 
I eeprxienced the same. Upgrade logs show the SQL 2005 SP3 hotfix KB970892 as successful, but after any reboot it is indicated as a neede important upgrade. After several attemps (each successful) I gave up. 
Re: Problem with SQL Server 
Author Majdi  Posting date 3/15/2012 10:20:52 AM 
说:Since the Monster dre beats headset can not msluiate the sound of the rear, monster beats there is no diffraction effects of the human ear, the sound field in front of largely distributed in the range of 180 degrees,dr dre beats all the sound elements (such as musical instruments) are evenly distributed within this range, from near and far from uniform. Beats by dre The reason to draw such a map,Monster beats bydre not to say that the only way the sound field distribution is correct, but to facilitate discussion of a hypothetical,dr dre beats assume that the distribution of various musical instruments is indeed the case,beats by dre and through the sound system is the ideal way to restore Beats by dre sale. 
SUBJ1 
Author epajccdelcet  Posting date 5/1/2012 10:10:40 AM 
lancel brigitte bardot noir
Lancel Sodes<>/url]
sac lancel ebay
 
Re: Problem with SQL Server 
Author Yaxii  Posting date 5/20/2012 1:46:40 AM 
说:Since the Monster dre beats headset can not smialute the sound of the rear, monster beats there is no diffraction effects of the human ear, the sound field in front of largely distributed in the range of 180 degrees,dr dre beats all the sound elements (such as musical instruments) are evenly distributed within this range, from near and far from uniform. Beats by dre The reason to draw such a map,Monster beats bydre not to say that the only way the sound field distribution is correct, but to facilitate discussion of a hypothetical,dr dre beats assume that the distribution of various musical instruments is indeed the case,beats by dre and through the sound system is the ideal way to restore Beats by dre sale. 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/4/2012 9:38:23 PM 

There is not any specific which means concerning the Scorpion. This vivid and amusing scorpion is manufactured through blue teeth enamel and also dark nickel hardware. There may be the Gucci emblem on the buckle bottom. I imagine the scorpion clasp will be the soul and also heart and soul of the developer belt. This dark buckskin belt actions 1.6 inches wide and it is offered by a price associated with $325.00. Before purchasing this kind of fashionable belt, you must find out their size. Measure within the waistband associated with their jeans as well as size-up 1-2 sizes. Now this particular buckle is available at an entire array of sizes.
 
Re: Problem with SQL Server 
Author Kyla  Posting date 6/5/2012 4:06:39 PM 
I appreciate you tainkg to time to contribute That's very helpful. 
Re: Problem with SQL Server 
Author Ilarion  Posting date 6/5/2012 9:52:58 PM 
That's an expert answer to an interesting quetiosn 
Re: Problem with SQL Server 
Author Peot  Posting date 6/6/2012 2:48:55 AM 
Gee willkeirs, that's such a great post! 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/6/2012 5:13:24 AM 

is an ideal day bag together with lots of space web hosting and also company items. And it really is versatile. At work or perhaps around the holiday you'll be considered as a woman of style with this particular carrier on your own shoulder.
 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/7/2012 4:43:47 AM 

There isn't any special which means in regards to the Scorpion. This vibrant and humorous scorpion is manufactured through azure enameled surface as well as dark pennie hardware. There will be the Gucci logo about the clasp bottom. I imagine that the scorpion clasp is the heart and soul and also essence of this designer belt. This african american leather belt actions 1.6 inches broad which is offered at a price of $325.00. Before purchasing this type of stylish belt, you must determine his / her size. Measure over the waistband of their jeans and size up 1-2 sizes. Now this particular buckle will be offered at a complete array of sizes.
 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/7/2012 6:02:44 PM 

Do you like handbags? In this article there is a finest Coach, Gucci, Prada and other developer handbags regarding 2012. Styles will always be changing and also 2012 is no different. This yr the top developers possess develop some really awesome stuff. Many of those designers are usually integrating cutting edge technology using the newest the latest fashions to create absolutely extraordinary handbags.
 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/8/2012 7:31:20 AM 
I am just a regular individual working in Saudi Arabia. Instead of purchasing the actual original, genuine, expensive signature handbag, I prefer to selected look-alike gucci bags that will help save me a great deal of money. Nowadays, increasingly more look-alike bags along with sophisticated design is in the market today. Eventhough they may be merely reproduction of those original worldwide high end handbags, it provides a special design as well as good quality. Plus, 100% shown compared to that authentic gucci 
SUBJ1 
Author vodyIdeaxasse  Posting date 6/8/2012 3:40:39 PM 
I 'm merely a regular person working in Saudi Arabia. Instead of purchasing the particular original, genuine, pricey personal handbag, I choose to selected replica gucci hand bags that will help save me a lot of money. Nowadays, a growing number of reproduction bags along with stylish style is actually on the market today. Eventhough they may be simply look-alike of these unique global luxury handbags, it features a distinctive style and also great quality. Plus, 100% shown compared to that unique gucci 
Re: Problem with SQL Server 
Author Moayad  Posting date 8/14/2012 12:00:43 AM 
03.23.11 at 10:01 amSouthPawI like how he didn't directly or irtcneidly answer the Dre question smh completely dodge the question. What I understood from that answer was no one is no longer paying attention to me, so I'm going tweet to generate some controversy and interest bc I'm 50 and I dropped some head phones and no one is talking about them so what better way for people to talk about them ummm..let me do what I usually do WWF, and talk about Dr. Dre's head phones and how he's mad I came up with my own line (which is totally not true), but hey I need to eat so screw it I'm 50 cent, and that has been an official tantrum of mine.ON DR. DRE’S REACTION TO HIS SLEEK HEADPHONES“I have a strong personality, a strong character. And I can be difficult to deal with at certain points because I’m vocal. If you upset Em, he’s just gonna not talk to you. You’re not going to get him in the next room you wanna get him in. With Dre, the same. He’s not comfortable with friction. That [tweet] is, “Hey look, I’m here. Is everybody still paying attention?” So they go, “Why he say that? Why he say we mad?” Then the meeting happens.” 
Re: Problem with SQL Server 
Author Yunrendorj  Posting date 8/15/2012 8:04:22 PM 
03.23.11 at 2:23 amBryan@Scott Tell me why mofo's like you have a one track mind? How do you act black? Is speaking English mean we're acintg British? Every heard of being a product of your environment? Did you mean no rhythm? Then you talk about Jordans. So me wearing the Jordan 13 Playoffs I just bought on Feb 26th is offensive to you? What should be offensive to you is how much money we spend on those Jordans that cost peanuts to manufacture. Not sure what you got against white people but that's your choice. I have been down with hip hop culture before you even knew what hip hop was, so technically you're acintg like me and others before you not the other way around.But whatever grudge you have you should let it go. I don't know about you but only color I care about is green cause that's the only shit going to pay my bills. So me being a music producer and lets say you were a rapper, you'd be biased taking a beat from me no matter how banging the beat is solely because I'm white? Feel sorry for your train of thought. 
Re: Problem with SQL Server 
Author Freddie  Posting date 9/20/2012 1:12:01 AM 
03.23.11 at 10:01 amSouthPawI like how he didn't directly or inetrdcily answer the Dre question smh completely dodge the question. What I understood from that answer was no one is no longer paying attention to me, so I'm going tweet to generate some controversy and interest bc I'm 50 and I dropped some head phones and no one is talking about them so what better way for people to talk about them ummm..let me do what I usually do WWF, and talk about Dr. Dre's head phones and how he's mad I came up with my own line (which is totally not true), but hey I need to eat so screw it I'm 50 cent, and that has been an official tantrum of mine.ON DR. DRE’S REACTION TO HIS SLEEK HEADPHONES“I have a strong personality, a strong character. And I can be difficult to deal with at certain points because I’m vocal. If you upset Em, he’s just gonna not talk to you. You’re not going to get him in the next room you wanna get him in. With Dre, the same. He’s not comfortable with friction. That [tweet] is, “Hey look, I’m here. Is everybody still paying attention?” So they go, “Why he say that? Why he say we mad?” Then the meeting happens.” 
Re: Problem with SQL Server 
Author Anjel  Posting date 9/20/2012 4:25:50 AM 
03.22.11 at 3:18 pmscotttell me why white mfkahhuuters be on a black hip hop site trying to be cool and act like they black that shi!!!!!! looks so stupid when a white boi trys and act black .. first off they have no rhythem so when they try and act black or move around like a black person it looks funny as fuk lol lol lol whites so happy to have eminem and yelawolf .. now they feel like they black everytime i see a white boi acting black .. i bust out and laugh you see a white boi with a doo rag and a pair jordans on .. that shi!!!! is tooooo funny.. you know why . because a white person has no swag in their body what so ever . u see that white chick in the (sundrop soda commerical)danceing to (drop it like its hot) she had no type of rhythem or swag at all that shi!!! looks to funny . remember they made a movie making fun of white people acting black . (malibu most wanted) 
Re: Problem with SQL Server 
Author Kenyyans  Posting date 9/20/2012 5:10:05 AM 
03.22.11 at 5:13 pmGUNDOGGYSpot on @over.. Yeah that Scott person is alyaws spamming the same exact message on every site. It's obviously to throw you off topic Funny thing he could be a white guy trying to stir up some racial tension on these bloGS Regarding 50 s comment sooner or later it won't really be such a big deal to have a face tat and still hold down a regular job. So it's not that big an issue. Fif sounds like he's been tamed and is under the corporates thumb Damn homie in 03 you was the man homie, what the fuck happened to you??? 
Re: Problem with SQL Server 
Author Abdo  Posting date 9/20/2012 7:58:58 AM 
03.22.11 at 4:34 pmLISSSSSTEN@scott, that is a RACIST comment. it dont maettr what color skin you are, its about how you raised & who you be with. ive seen plenty of soft ass BLACK PEOPLE who live in the suburbs & act white all the time. on the other hand ive seen WHITE people, live a HOOD lifestyle. SKIN COLOR DOES NOT MATTER. 
SUBJ1 
Author pletcherzzo  Posting date 11/27/2012 6:26:30 AM 
Asleep over the chair from the vanity mirror front of your stage sat down, picked up the journal over the dresser. It seems that she is ready so sitting down go along with Rayong tremendous till dawn. Also ah! Approximated if for you personally, round these kinds of a big Yinzei all around, you could potentially stay awake! 鈫?Chapter 026 - Your room is really aromatic carrying torn attire, barefoot wearing a hands desk of Rayong tremendous bitter encounter sitting inside a wood chair, and my coronary heart is with blended thoughts ah! Take into consideration how his previous status can ......

Took out a miniature handheld notebook and handed Rayong super. All there may be? Rayong extremely absolutely cannot are convinced this way because of the Chinese police have actually been type of factors. Missy seriously isn't there. Oh, the original Terminator is some guiding the item, I get it! Lee nirvana finished, started through two hundred the alloy box of password are entered, the greater than two hundred robots start out up. Experienced meant to begin immediately after they returned to Earth, but curious Lee nirvana or stopped to watch them look and feel. They witnessed no comment on the implementation of your procedure nearly every 10 team towards formulated in a few directions from your relentlessly digging.

Did not recuperate. You disperse out all repair, go on crossing robbed! Wang Lin perfect mission five read through Ray take in all standing in mid-air, bit by bit opening. The middle-aged guy took a profound breath, depressed heart uneasy, deeply appeared Wang Lin, a systemic maintenance is instantaneously unfold of Shennong peak electricity of heaven and earth flooded.

The days from the tyrants that you will discover black with blood dripping, revealing unlimited bloody, but crash left boundary closure large array specifically dissipated inside heads of Wang Lin. That meteor hammer right after the high temperature wave, he could actually feel a big flame catapults roaring metamorphosis, this chariot hideous very similar letters sector array Spirit, through the ages died for the sector inside the bounds of maintenance, countless , almost all of which might be inside the boundaries of men and women! In the moment this chariot drawn heap fog crashing fall apart rapidly dissipated near towards the affect. Right after the chariot, golden lofty, a golden sword metamorphosis monstrous purple and gold immediately following diffuse big array about a minimal understanding of the purple whip unreal out, there are many Rune imprint on this whip trouble pops Voice, distortions this sort of as pythons! Whip seems the seal array shocked,.

Wang Lin, facing Shili vacant space inside of 6! Which a repair seriously isn't weak, along with the remaining five belonging to the costume, but I've some familiar! Six! Wang Lin eyes flash. I am going to consider you to dismantle see! Zhou Yi God concept came the moment and integrate to the physique of Wang Lin, with his soul, in in vitro underneath purple absent, throughout giant tracts of Purple Haze. Miles outdoors the vacant area, came precisely to Wang Lin only come to feel eyes mist.
 
SUBJ1 
Author pletcheroff  Posting date 11/27/2012 11:06:29 PM 
Asleep about the chair with the vanity mirror entrance from the phase sat down, picked up the magazine on the dresser. It seems that she's ready so sitting down go along with Rayong super till dawn. Also ah! Believed if in your case, near this kind of a sizable Yinzei about, you can stay awake! 鈫?Chapter 026 - Your home is basically fragrant putting on torn apparel, barefoot putting on a hands desk of Rayong super bitter confront sitting in a wood chair, and my heart and soul is with blended inner thoughts ah! Think about how his earlier status can ......

Took out a miniature handheld notebook and handed Rayong tremendous. All there may be? Rayong extremely genuinely cannot think this fashion with the Chinese police are actually sort of matters. Missy shouldn't be there. Oh, the original Terminator is some driving the product, I get it! Lee nirvana concluded, began more than 200 the alloy box of password are entered, the greater than two hundred robots commence up. Had intended to begin soon after they returned to Earth, but curious Lee nirvana or stopped to observe them seem. They noticed no touch upon the implementation from the program nearly every 10 group toward developed in quite a few directions from your perpetually digging.

Didn't recuperate. You pass on out all fix, continue crossing robbed! Wang Lin precise undertaking five study Ray absorb all standing in mid-air, little by little opening. The middle-aged male took a profound breath, depressed heart and soul uneasy, deeply looked Wang Lin, a systemic mend is quickly pass on of Shennong peak strength of heaven and earth flooded.

The days belonging to the tyrants that you'll find black with blood dripping, revealing endless bloody, but crash remaining boundary closure big array immediately dissipated inside heads of Wang Lin. That meteor hammer upon the warmth wave, he could think a tremendous flame catapults roaring metamorphosis, this chariot hideous remarkably the identical letters sector array Soul, with the ages died about the sector inside the bounds of repair, numerous , a majority of which can be within the boundaries of folks! With the instant this chariot drawn heap fog crashing drop apart easily dissipated around toward the impact. Subsequent to the chariot, golden lofty, a golden sword metamorphosis monstrous purple and gold once diffuse great array about a tiny knowledge of the purple whip unreal out, there are numerous Rune imprint on this whip difficulty pops Voice, distortions like as pythons! Whip appears the seal array shocked,.

Wang Lin, before Shili empty space in six! Which a maintenance is simply not weak, along with the remaining five from the costume, but I have some acquainted! 6! Wang Lin eyes flash. I am going to acquire you to dismantle see! Zhou Yi God idea arrived the second and combine to the system of Wang Lin, together with his heart, within just in vitro underneath crimson away, across considerable tracts of Purple Haze. Miles exterior the empty area, arrived specifically to Wang Lin only think eyes mist.
 
Re: Problem with SQL Server 
Author Momin  Posting date 1/3/2013 10:43:46 PM 
Do you have more great airtcels like this one? 
Re: Problem with SQL Server 
Author Princessita  Posting date 1/4/2013 3:34:22 AM 
/ Thank you so much for providing inidvdiuals with an exceptionally breathtaking opportunity to read from this web site. It is always very excellent plus packed with amusement for me and my office co-workers to search your web site on the least three times every week to read through the latest guidance you will have. And lastly, I am also always motivated with your fantastic ideas you give. Selected 1 ideas in this post are surely the most efficient we have all had. 
Re: Problem with SQL Server 
Author Ela  Posting date 1/4/2013 5:09:38 AM 
/ I have been surfing on-line more than three hours these days, but I by no means dievecsrod any attention-grabbing article like yours. It is beautiful price sufficient for me. In my view, if all website owners and bloggers made excellent content as you probably did, the internet shall be a lot more helpful than ever before. 
Re: Problem with SQL Server 
Author Lahcen  Posting date 1/6/2013 6:10:14 AM 
/ Ia1a6ve been exploring for a lttile for any high-quality articles or weblog posts in this sort of space . Exploring in Yahoo I ultimately stumbled upon this web site. Reading this info So i am happy to convey that I have a very excellent uncanny feeling I discovered exactly what I needed. I such a lot unquestionably will make certain to dona1a6t disregard this website and give it a glance regularly. 
Re: Problem with SQL Server 
Author Alma  Posting date 4/5/2013 9:13:24 PM 
Hi! Didn't think anyone would see this blog area.1.5.0 Demo has no image soarwfte at this time, although the new Image Handler 4 is now out. Will test it soon.If you saw the jz Black 2 template I was testing, yes, that came with a nice pop-up. Similar to Lightbox in some ways I think better. This demo cart has been deleted and I'm now starting over with Demo 1. 
Longchamp Le
 
Author jiuexybxm  Posting date 11/1/2014 7:47:17 AM 

 magasins salsa du continent où le shopping carnaval présenté conjointement le 9 Novembre 2012 au 11 Novembre visite Salsa (Chine) magasin pour faire #links1 des emplettes qui bénéficient des avantages suivants: <br /> magasin de Salsa visite lors de l'événement, 50% de rabais sur certains produits désignés marque. 1, les marques participantes: RSB, Suisse (Programme Suisse), Methode SWISS (Swiss), BERGMAN (Pays-Bas Bergman), Natio (Na Diao), UNIK, Sasatinnie, Neogence (Neogence) , combinaisons de couleurs, LES COULEURS DE CYBER, SWISS Rituel (Rui Shiluo fontaine), MARINA DE BOURBON, SOIE WHITIA, Bioessence (Kaye Show), Olivia (European Rugby), Biofresh (Kerastase), DR. multiples variations du problème du sac à dos , 'sac à dos neuf contraintes' de dd_engi donne un résumé détaillé. Grandement bénéficié. GRACY sac à dos oblique est plus <br /> appropriée pour les voyages Voyage de lumière, comme le dit le dicton, bien que petite, parfaitement formé, stylos, téléphone portable, rouge à lèvres. Principaux éléments peuvent être trouvés dans #links2 chaque de sa position exclusive dans ce sac très fonctionnel; #links3 faciliter modèle de sac de messager, mais aussi pour la robe d'été Sac Longchamp des femmes d'amusement qui veulent apporter plus de confiance. J'ai décidé, et donc fini les examens finaux de ces jours, je tiens à s'enfuir de la maison, puisque le père ne voulait pas que je donne naissance à cet enfant, je ne serai jamais donner naissance à cet enfant devant son père, et ne vais pas le laisser me s'opposent La décision, couplé avec mon père avait une pression artérielle élevée, il ne peut pas se permettre de stimulation, alors je suis parti et le bébé est la meilleure décision. Enfants Jane Kwai compris le problème, je pense que <br /> la vie soudainement devenu clair, le voyant à l'avant.


 
Chinese shoes - 'Chengdu shoes' open the door to Central Asia
 
Author mujacmingaah  Posting date 11/24/2014 12:02:22 AM 



 
Coach outlet 
Author Coach outlet  Posting date 5/6/2015 5:48:51 PM 
Weight loss tips and free help and advice to help you loose weight fast in a healthy and natural way. 

Post reply
Author *
Topic *
Message *

   Visit our sponsors:
Visual PHP and Web Development, Web Reporting