im trying to create a function that accepts a sql statement as a parameter,
makes a db connection, returns a recordset, and inserts all items from the
recordset into a data dictionary - then i want to set the value of my
function equal to my newly created dictionary of items from the recordset -
this is where im having a problem. is it possible to set a function equal
to a dictionary? i cant seem to make this work and it seems that this
should be possible.
Code: function findcinemaid(nameofthecinema) findcinemaid = "select cinemasid from cinemas" &_ " where brand = 'tgv' and cinemaplace2 like '"&nameofthecinema&"'" set cinemaidfound = objconndb.execute (findcinemaid) optainedcinemaid = cinemaidfound("cinemasid") end function
i am trying to write a function which will add an entry to to a table in my DB and then return me one of the values of the newly added entry.
For e.g. I use the function to add a new Order Entry into the DB, but i would also like the function to return me the value of the OrderID field for the new entry. Code:
is there a way to 'force' ASP date function to return date in a given format; I mean, my need is to force 'date()' function to give me system date in italian format instead of english (O.S. is in english as well as locale settings for IIS anonymous user); is there a directive or something similar to put in ASP code?
Can anyone tell me why the funciton checkCode returning in the middle of the for loop breaks the for loop? ie. If I remove the section:
if checkCode("0011") = 1 then response.write "<br />Passed submission of user code" else response.write "<br />failed submission of user code" end if
from the code snippet below, then the code will successfully loop through and print out all the post var fields (there are in fact 4).
If however you leave this in, the function returning seems to break the for loop from continuing through all the other post variables after "user_code" Code:
I am working on a project which used dictionaries. I am having to remake part of this and have no experience with the scripting dictionary. I need to see how to create multiple dictionaries within one dictionary. Can someone point me to some reading materials on this where I might see an example as well?
Just wondering the best way of doing this? are there any dictionary databases laying around somewhere?
I want to change my search so that it corrects typo's and maybe suggests better words to search with... like googles but with more alternative words to make the search more useful - slightly limited so it doesn't become pages and pages of search terms.
What I don't want to do is sit down in front of my computer and type all of this in, going through related words and possible other searches / best searches from the given input.
While pouring over some code I've discovered a previous developer heavily uses the "dictionary" object. Whilst I see some of the advantages of using this system It's something I've not used myself so am not sure of the limitations.
We are about to widen the scope of the website it's being used on to a WorldWide system - greatly increasing the number of users that will be using the website.
What I'd like to know is are there any performance issues with using this on a heavily used site?
I am trying to store some data in a Dictionary object. I am getting errors though about adding duplicate keys. "key already exists"
I commented out the obj.add and just did a .write of what exactly was being added each time. There never was a time when a key was being added twice ....
I proceed much further whether it is possible to pass in the Dictionary object (Scripting.Dictionary) from ASP to a stored procedure in SQL Server. Any sample sites or simple code examples would be really great.
I need an ASP dictionary/glossary script. I saw a bunch of options online for PHP but almost nothing for ASP. I'm not a programmer....but can install working code and connect a database. can anyone recommend a tutorial or even better a finished working piece of code I can implement to create my own dictionary with custom definitions?
I have to develop a spell checker from scratch using asp language. as i'm a newbie with asp, there are still a lot of things that i don't understand. How can I add new words to my list of dictionary sorted alpabetically?
Do i need to use the database for this function? Can anyone show me? or if anyone knows of any websites that i can refer to.
After going back to the start, I eventually realised that the dictionary Item property didn't like 'rsNetStock.fields("PartNo")' as a parameter, so I had to use something like the following:
I have a problem with the Scripting.Dictionary in ASP. All my data is entered into my Dictionary with no order and I would like to order them alphabeticaly and I don't know how to do.
I'm having problems with an array of dictionary objects. It is being used to organize an SQL catalog set up with an ID/ParentID scheme. The script uses recursive functions to return the children categories, and works fine except for storing the info in the array of dictionary objects.
The UBound of the array is correct, and the very last index (93) to the array seems to have the correct dictionary object, but all the previous (0-92) come up with "Object Required:" error. By the way, dicRecords is another array of dictionary objects taken from a recordset. Any ideas? Code:
i'm trying to page through the items in the Dictionary, i've got a great example on it, but the way my class and dictionary is set up won't allow me to use the example Code:
I'm using Server.CreateObject(Word.Application) to execute a spell check. Works fine, but we'd like to add a few of our more common company-isms to the dictionary, as they're getting flagged every time.
I tried opening Word on the Server and adding one to the dictionary. I also tried it locally (which didn't make any sense, but still). The word still shows up as an error. Is there a way to customize this dictionary?
I have a server running Windows Server 2003, on which two of the web sites use the MegaBBS ASP forum software. Both sites suddenly developed the same error, which seems to be connected to the dictionary object.
I got two ASP pages. One is ASP email form (I'm using Persist ASP Email component). Another one has all file links in it. For example, when user click Outlook course hyperlink. It will pop up another window with outlook course PDF file. (All PDF files are already in the server).
What I am trying to do is: When user click the "Add Email" hyperlink, it will add that course name and filepath into ASP/VBScript Dictioanry Object. After the user finish and click "Attach to email" button. All the files will be attached in the email as an attachment.
Because I am not familar with VBScript. So, can Javascript add items to ASP Dictionary Object?
Ok, first I had a problem with that error code: 0x80020009, but this article http://support.microsoft.com/defaul...b;EN-US;q175239 fixed that. I'm saying this because it might still have an impact..... I don't know.
I'm using scripting.dictionary for my webshop, so I'm putting the scripting object in a session variable.
So you can order three types of things, and I have one page that lists your shopping cart before checkout.
When I display only one of the three types (ie delete the rest from the file) it's all good. when I try to display them all, stuff just dissapears. If it wasn't for the fact that it works with one type, I would have thought it was something with some of the if syntaxes. Code:
I have a dictionary object,then I create a new dictionary object and sets it equal to my original,then I pass the new dictionary object to a function that changes some of my values - but then my original dictionary also gets changed and that was not the intention.
can someone explain to me why it behaves that way and how do I avoid it.så I van have different dictionary objects?
