|
I am afraid I do not understand the question, but your parameters in stored procedure - shouldn't you be using something like:
@middlename NVARCHAR(255) = NULL
|
|
|
|
|
What I am trying to say is... If the textbox is empty, a null should be written to the database field. So, if I pass the null contained variable to the CreateParameter method, then I get errors. I want to test for nulls before I go to the database.
|
|
|
|
|
ok....
try isNull or isEmpty ...one of them should work! gosh, it's been a while since I used vb!
|
|
|
|
|
Lets say I have a textfield called txtTel. This is an optional field as the user doesn't have to enter a value. So if the nothing is entered I do a small test, something like:
Dim strTel
If Trim(Request.Form("txtTel")) = "" Then
strTel = Null
End If
Then I use this strTel value in my CreateParameter as a parameter. And because it is null, it doesn not work. It does work if if I make strTel = "".
Cheers
Brendan
|
|
|
|
|
can you just not include that parameter in your sql statement?
<br />
If Trim(Request.Form("txtDialCode")) = "" Then<br />
' do nothing<br />
Else<br />
objCmd.Parameters.Append objCmd.CreateParameter("@ContactDialCode", adWChar, adParamInput, Len(strDialCode), strDialCode)<br />
End If<br />
/jason
|
|
|
|
|
I want to create a perl script.
If we run perl script at the end of the day it should check which all users copied, moved or removed the files on the unix server (i.e. the script would be run on unix server). Suppose there r 10 users.
In short i want to know who all used the cp, mv or rm command at the end of the day.
Plz. let me know as soon as possible
Is it possible
|
|
|
|
|
Which shell are you using? I know with bash, as well with others, there is a history file of commands used by a specific user. It would be easy to write a script that would read that and then wipe it out when finished...assuming your shell has a history file, that is.
|
|
|
|
|
My boss would like make peer evaluations done on an electronic basis, he needs each employee to fill out a form like:
-your name "tom"- -person being evaluated's name "bob"-
q1 - response
q2 - response
ect...
The admin should then be able to do a search for "bob" and then a summary report will be made with the questsions asked and every ones responses about "bob"
q1 - "bill's response"
- "tom's response"
but none of the submitted reports should be accesible to other users besides the admin. So how can one submit something then not have access to it? i know its a simple problem but.... gah.. We are on a lan so right now i need to figure out how to keep the users out of a dir but allow them to submit to that dir.... any ideas?
|
|
|
|
|
Backend database with admin group and user group, where admin will have full access and users limited?
A web form with login for admin and users and dispaly summaries only for admin? Remember, when a user "submits", the page is processed on the server side and you can do a lot on the server!
There is more than one way to handle this...some of the others may have some suggestions too.
|
|
|
|
|
thanks guys, i think i've actually found out how to do it, since its on an intrAnet and not public access. I'ma using frontpage (srry... *crys*) to make a .asp page that will submit to a database and I will be using PHP to retrieve info for later reports.
|
|
|
|
|
Hi, all
I want some Design templet to develope web site to use it ...........
so plz send it to me...
samir vohra...
samir_i_vohra@yahoo.com
plz put subjetc line same...boss
|
|
|
|
|
No-one is going to send an email to an anonymous poster. If you don't care enough about this site to register, or even come back to read our replies, why would we bother ?
Your question doesn't make sense to me. What do you want, a design template to build a website in terms of the look and feel ? Using what language ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You can google for template and free.
<italic>Work hard, Work effectively.
|
|
|
|
|
Can anyone recommend a commercial PDF server product?
Apologies for the re-post, first post was in wrong forum.
|
|
|
|
|
Hello all
I am redirect the user to the index page as he login but what I have to do is to redirect him to the same page plese help me
neeru
|
|
|
|
|
which page do u want him to redirect ?
i am not getting your question ..can u clarify a bit more ?
Abhijeet Jadhav
|
|
|
|
|
If you meant redirect him after login to the same page that he was in ?
Then use:
RedirectFromLoginPage(); Method in the Authentication class.
|
|
|
|
|
but i am working with asp not with .net
|
|
|
|
|
Will pay experienced programmer to teach me PHP/MySQL. I am a C++ programmer who needs minimal support.
Send brief resume and required hourly rate. We can start 1 hour at a time using Paypal.
I am particularly interested in building a real estate information form which in turn will propagate a MySQL database.
Jim Osborne
josborne@starband.net
|
|
|
|
|
If you remotely know C++, then you're wasting your money. Why do PHP anyhow, are you being forced to ? What's wrong with ASP.NET ? MySQL is pretty crappy too, although it's free for non commercial use, MSDE is just plain free, and kicks it's ass.
I recommend reviewing your architecture of choice, if you have a choice, and then buying some books and asking questions here.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I am using PHP/MySQL because it works well and is easy to learn. I need to get a real estate information system on-line ASAP. If I had the time and big bucks I would go with Coldfusion.
Years ago I used MS Sequel Server version 4 with C++. The code was difficult to maintain without ample training and due diligence. I heard MSDE is a much better database but then I have to go down the MS road again.
Thanks for your input.
sundownr
|
|
|
|
|
sundownr wrote:
I am using PHP/MySQL because it works well and is easy to learn.
So easy that you want to pay a tutor....
sundownr wrote:
If I had the time and big bucks I would go with Coldfusion.
What's wrong with doing it with ASP.NET/C# ? If you know C++, that would be a breeze for you.
sundownr wrote:
Years ago I used MS Sequel Server version 4 with C++. The code was difficult to maintain without ample training and due diligence.
The main problem would have been ADO. You think that using a crappy database will help you here ? I doubt it. Does PHP provide a dedicated layer to MySQL ? I doubt it would be as rich or useful as ADO.NET is.
sundownr wrote:
I heard MSDE is a much better database but then I have to go down the MS road again.
And that's bad because ? ASP.NET is simply the only viable choice for web development. PHP was good in it's day, but that day is long gone. ASP was and is a hack. J2EE is just too complex and hard to use. ASP.NET is totally killer, and really easy to learn to use, not to mention that the web abounds with info.
In all seriousness, I guarentee I could develop this site for you in C#/ASP.NET/MSDE much faster than anyone could do it in PHP using MySQL. I think you're making poor choices here, not least because your background in C++ actually empowers you to learn the best web development platform ( and it's totally free, unlike MySQL, which costs money in this case ( unless your real estate information system is theoretical or totally non-profit ).
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
If his server is Linux/Unix based, will the MS stuff even work?
------- sig starts
"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
John Simmons / outlaw programmer wrote:
If his server is Linux/Unix based, will the MS stuff even work?
OK, I'll admit that as he did not specify this, I assumed he was using Windows. I have no idea how far along Mono is, although I thought it was in a usable state, I would do serious research before trusting it. Obviously, there would be no MSDE support.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
ASP.NET is simply the only viable choice for web development. PHP was good in it's day, but that day is long gone.
Pffffffffffft...
Normally I wouldn't disagree with much of what you say in reagrds to programming...you've helped me countless times in C++...
However...that statement clearly suggests to me...you have no idea what your talking about when it comes to web development... 
Anything you can do in ASP.NET I can do in PHP...not nateively maybe, but i'm sure there is a library or something written in PHP which allows you to do anything you can do in ASP.NET and in some cases better...
PHP so I understand, is the most popular scripting language around...and for good reason...perhaps the source I got that from was being biased...but IMHO...PHP seems to power most web sites...
PHP scripts are a dime a dozen....for anything you can think of...there are atleast a dozen scripts available ranging from "amatuer coder" to highly "skilled professional"...
PHP I would argue is just as fast in execution if not faster than ASP.NET by virtue of the fact it's OSS and has so many eyes looking at it making optimization changes and the Zend engine likely being written in C for a Linux system. I'm not sure how the two compare byte for byte but in all honesty how can a Windows system execute as quick as a cut down *nix machine running only the required software???
PHP lacks in some RAD/Development areas...like it's OOP support is poor, but that's ok...PHP5 is alot better...besides PHP usually attracts more experienced Linux developers...
There is a definite lack in quality IDE's...I still sometimes use VC++ 6.- IDE 
Other than that IDE fact...I would still very much so prefer to use PHP...
BTW-Hosting is half the cost...
As for MySQL? You can use other databases...quit easily...however there are some mega major web sites (so I understand) which are currently using MySQL...so it can't be that bad...
Christian Graus wrote:
not to mention that the web abounds with info.
I don't think so...[^]
I think M$'s advertising is paying off...they've brain washed you
Cheers
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
