Testing For Null In Filter Property
Is it possible to test a string column for null in the filter property of a RecordSet object?
rs.filter = "display = '' "?
This doesn't return any rows.
Is it possible to test a string column for null in the filter property of a RecordSet object?
rs.filter = "display = '' "?
This doesn't return any rows.
I'm using the Microsoft.XMLDOM object in an ASP page to read an incoming XML post request and respond to it. Although the XMLDOM object verifies the XML at a basic level, I want to make sure that the request is in the correct format (as per the specification I have to work to), as well as making sure that any XML at all was sent successfully.
At the moment, I'm stuck at the point of just trying to make sure that an XML request was sent at all. Here's the code I'm using. note that I'm loading the XML from a file for ease-of-testing, but am giving a bad filename so as to create the condition where the XML didn't load successfully.
How do test my web application for concurrent users (how much concurent user connect at a time and how traffice will be affected and what will the response time?) and how it is done, how long it will takes, does it interfere with current site, etc.?
Reagarding the number of users the site will accomodate is it based on where it's hosted
Application written in ASP/Sql Server. Code:
I have an interesting situation that needs to be addressed ASAP.
I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.
The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.
In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.
I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
there is a property in asp.net called autopostback, what i want is to set this property
on plain asp to give a combo the ability to postback the selected option.
Is this possible???? i need to set something like that to a dinamic combo, any ideas????
If it can be done in java or vbscript just please tell me, cause i don�t have a clue if is possible or not.
Ive written some ASP code to list information from a table in my database.. what i need is a drop down list to list all the regions (provided by a table called tblRegion), and when the region is selected that re-queries the list.. Code:
View Replies View RelatedI've got a website that I've been making some changes too as of late. It's not my website so I've been learning a lot, especially since I'm fairly new to coding and webdesign. So keep in mind, I'm just a newb. If there's not enough info here to allow anyone to help, just say so and I'll figure it out on my own. Here's my problem...
This site I'm working on has all kinds of directories and allows certain people within a company to upload files to certain directories. I've got a .asp file that shows all of the content providers for all directories in a table.
I want to make it so that in my directorylist.php file there's a button that will allow a user to click on this "View Content Providers for this Directory" button and it will read/filter this asp file, and spit out a list of only the users who have authority to upload files to that particular directory that the user is looking at.
Is there some way to link the two files to do that? Or is it just a change I need to make in the loop in the asp file or perhaps a change in the php file? I'll provide a piece of code from the .asp file. Code:
On my page i run a SQL query that selects certain records from the database,
Is there any way to select a specific record from the recordset then another one. e.g. say i run a SQL that picks up all records with ID < 30 and then i want to pick one with an ID of 1 and then one with an ID of 4 without re-running the SQL query?
I had an sql statement like 'WHERE MID(id,4,1) = 3' but when I try to use the filter method it returns the error:
'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'
rs.filter = "MID(id,4,1) = 3"
Thats what its supposed to look like right
I've used Rs.Filter several time sin my code and they all work fine. However when I use
Code:
Rs.Requery adAsyncExecute
Rs.Filter = DateDiff("n",lastedit,NOW) < 15
I get
Quote:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Am I typo'ing something or can I just not use DateDiff in a filter?
I don't understand why but If I use vbscript the following code works
fine:
....connection string.....
dbConn.Open
msgbox dbConn.Property
but the corresponding code in asp:
...connection string.....
dbConn.Open
response.write dbConn.Property
returns the error "Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another" In both cases
connection to sql server is ok.
I have a requirement like this.When the textbox gets focus..at this even i want to change the input langauge settings.like arabic.
Currently i have to do it manually by pressing the Alt+Shift key..to toggle between twon langauages
when do u use property procedure for example
PublicProperty CompanyName() AsString
Get
Return strCompany
EndGet
Set(ByVal Value AsString)
strCompany = Value
EndSet
EndProperty
I've created a form and I want to add a timestamp to it. How do I do this? I'm using dreamweaver by the way.
View Replies View RelatedI have a few server controls on my page. Also I have a aspropDownList with AutoPostBack="True". When I select any value from the dropdownlist I want all the controls to be empty when my page reloads.
Can I use the EnableViewState property for this or I have to write specific code to do this? Currently the values which I had enetered in the servier side controls are retained after the postback.
does anyone know how to change dynamically a property in some word documents?(in vb, javascript or even if you've got a tool or something )
For example:
In my directories I've got docs with a property "version" I want a tool to update each "version" in my files...
Is there any way to make visiblitiy a combo box (2) in asp false when i used combo box (1) to select one item in the combo box(1) i want to make a combo box(2) which should be made visible false .
View Replies View Relatedtest my app? it's still in development but it's very much usable. i'm looking for few good object oriented souls that can look at this. i'm still adding few functions so don't be surprised if it goes down for a VERY short time (minutes really).
View Replies View RelatedI am trying to get my SQL Query to to through a list of faults, and pull all the records from the previous month (say now is july(7) it pulls all from june (6)
the current SQL i have is....
SELECT Faults.DateAdded, Faults.[Teacher ID], Faults.[Computer ID], Faults.[Type of Fault], Faults.[Description of Fault], Faults.Fixed
FROM Faults
WHERE ((Month([DateAdded])=Month([Date])-1));
but this doesn't work, can anyone assist?
I'm using APS VBScript web page on an Access2000 database and I am trying to select from a recodset using a date as the criteria.
I keep getting ADODB Data Type Mismatch errors no matter what I do to the database field (which hold a date/time) or the URL.
My URL looks something like ... result.asp?id='3/20/2005'...
The database field is an Access date/time field formatted to mm/dd/yyyy.
Isapi is installed and rules are working. Now I have to change the links of my shopping cart from dynamic to url friendly.
How can I change the internal links of my cart in an automatic manner (some script maybe)? I am trying to avoid to go trhought the proces of 'seach and replace'.
I know it is possible to do it in PHP with one scripf for each kind of friendly url link. I am wondering if this can be done in ASP, better said, if the scripts are already done ready to adapt as I am not a coder.
I have information in a database with the following structure:
3 Divisions - each division has several districts. Each district has several regions and each region has several areas.
I have a recordset of every area with the region, district and division they belong to.
I have 4 drop down menus on my page - area region, district and division.
How can I filter my recordset before each dropdown, so it only has DISTINCT records
How do I create an asp page that searches two tables in my database. I want to create a page with multiple drop down lists which a visitor selects to filter my database results. For example a visitor can select to search the database for products with COLOR red and SIZE large - or COLOR black and SIZE small - How do I do this? Is it complicated because I am new to this ASP lark
View Replies View RelatedI want to dynamicaly filter the members in my pivottable.
Here you see how it's done the static way:
pview.RowAxis.InsertFieldSet pview.FieldSets("manager)
Set fld = pview.FieldSets("manager").Fields(0)
fld.FilterFunction = c.plFilterFunctionInclude
fld.FilterMembers = Array("ZWAENEPOEL Geert","VAN COILLIE Caroline")
but I receive the selected members from another page, they are all in
the field 'selectedmembers', so I tried this:
fld.FilterMembers = Array(selectedmembers.value)
i have recordset rs on that i am applying filter as:
rs.Filter = " PRCD = '"&product&" ' and HQ_NAME='"&hqs"' "
here,PRCD is Column of datatype varchar(20)
HQ_NAME is Column of datatype varchar(20)
the problem is with PRCD,if substitue value directly as :
PRCD='SLO1NMK' filter is working but PRCD = '"&product&" '
not working.where as HQ_NAME='"&hqs&"' is working individually fine
Does anyone know where to find a good working MS Word-tag filter, or how to build this.
View Replies View RelatedI've got a Access database of business information.I've made an ASP page with 26 hyperlinks, relating to each letter of the alphabet.I want each hyperlink to fire up a page which only shows the business names starting with that letter of the alphabet.
How can I write the href?I've got:
<a href=cat.asp?business=<% = rsProds("biz") %>>A</a> that wouldn't work since we only want businesses starting with A to be shown.
How do I make the value for bizname pass an sql LIKE 'A%' statement to cat.asp?
Is there a way to minimize the code for each hyperlink or does each letter have to be written out?What will the SQL statement in the resultant page the variable's sent to (cat.asp) look like?
How can I filter by folder with ASP & Site Server 3.
I have no control over the catalog.
is there any option for using the functionality,given by filters?Does filter take lot of time?
View Replies View RelatedI got the following error when access an asp page.
Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/downtime_category-old2.asp, line 0
A default property was not found for the object.
I am using asp/vbscript/ado/mssql.
I am able to get the nullable property OK when generating a recordset
with a simple SQL statement such as "select Fld1,Fld2 from Table1" and
then looping thro' the fields and :-
Response.Write(rs.fields(x).attributes and adFldIsNullable)
When I use the following statement all fields are erroneously reported
as nullable:-
"Select B.Fld2, B.Fld3 From Table1 A Left Join Table2 B On
A.Fld1=B.Fld1"
Is this normal?
I connect to a Access DB and when trying to display the data from the DB, I get the followig error:
Object doesn't support this property or method: 'Fields'
The recordset does not support this property.
The script that I use is attached along with this thread.
Does anybody know what is wrong, is there a simpler approach to
display Access data on a Web Page?
How can I set the amount of Response.buffer? How can I block scripting if the buffer gets more than 2mb?
View Replies View Related