OK,
Here's a fun one for you. I have the following scenario that is not working. On our network, let's call it Network1, we have a Sonicwall 2040 set up as our firewall. We also do work with a remote company that has a Microsoft ISA server 2000 acting as their firewall on what we'll call...
I have a report that I created in Crystal X. I wrote a stored procedure in Microsoft SQL server 2000 that returns the data set. The wierd thing is that the Stored Procedure and the report work fine until I try to use one of the fields to do some grouping. At that point I get an error that says...
Also, I don't have a value to enter for the leadid. I want the leads table, the table which the trigger is inserting into, to assign the leadid. How do I accomplish that?
Anyone?
Matt
Jim,
That's what I tried doing but it doesn't end up in the LEADS table. Also, I don't get any errors. Is there a way I can check for errors?
Thanks
Matt
OK,
I have a trigger that doesn't seem to work. I'm assuming it's because the table I'm trying to insert into a table called LEADS that has a Field called "LeadID" which has a datatype of "bigint". The thing is that I'm not sure how to insert the rest of the data and have the LEADS table...
Hi...I'm begging for help.
What I'm trying to do is create a website template that gets populated based on a unique parameter ID in the URL.
http://www.application.com?ID=1
Using that value "1" that I get from the request.querystring I want to then be able to connect to a database and pull out...
Server: Windows 2003 Server Standard
Exchange: Exchange 2003 Server Enterprise
Legato Module: 4.0.2.372
Hi, we recently upgraded our exchange server from standard to enterprise edition and now we're getting errors when we try to backup our database store. We get the following error in the...
I'm running Crystal Enterprise 10.0 Report Application Server. I'm trying to make it acessible to some of my users outside of the office. However, I need to know what ports I need to open up on my firewall to allow users to get through it.
Please help
Thanks!
Matt
OK, so I'm not sure how to go about this. I have a column in one of my tables that stores the URL to a file that is saved on the hard drive. We then use that value to display a link to the file within our application. We recently copied all the files that have been uploaded into our system to a...
OK,
I'm extremely new to this so here's what I'd like to do and I'm not sure how. Currently we store usernames and passwords in a table for a particular function. What I'd like to do, is go into that table and add the number "1" to the end of every password based on certain criteria. This will...
Well, technically it's Owner_Name. So, I changed both and I still get the error. Besides, I didn't think that was case sensative but good idea.
Still getting same error.
Positive.
Ther response.write is showing this:
Select Owner_name from Branch where Branch.id = 2
That's also a field in the table. I don't understand it.
Thanks
Well, the above query works now but I have another query that's oh so simple and it doesn't work. I'm opnly trying to pull one bit of data. I've checked the spelling but it's still getting the one parameter expected....
Sub writeBranchManName()
Dim objConnInfo, objRS, Query1
Set objConnInfo...
I know that I changed that line, I renamed the query so that's not the issue but here's a copy of the error I'm getting:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/lendia/aspFunc/aspFunc.asp, line 598...
Well,
I've tried really simplifying everything. I'm just trying to pull one value. I'm still getting that error it just says one parameter expected.
Here's what I've got
Sub writeBranchInfo()
Dim objConnInfo, objRS, Query
Set objConnInfo = Server.CreateObject("ADODB.Connection")
Set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.